Why would a vlookup function stop working in excel 2003?
 

The Vlookup was working fine - and then it stopped working completely. Is
there a refresh or something in the naming of the list?

Why would a vlookup function stop working in excel 2003?
 

When you say 'stopped working', what do mean? Does it not calculate at all,
or does it just show and error (#N/A)?


--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Patti" wrote:

The Vlookup was working fine - and then it stopped working completely. Is
there a refresh or something in the naming of the list?

Why would a vlookup function stop working in excel 2003?
 

If it worked once, it should work twice.... unless....

Your workbook may have gotten set to Manual calculation mode. This can
happen if you open a workbook set that way and later open other workbooks
during the same session.

You mentioned refreshing the naming of the list. I have seen Excel lose
track of named ranges in the past (older versions of Excel as 97, but not
lately). It may have done that. Try changing the formula to use the actual
addresses of the upper left/lower right cells of the table instead of the
name you gave the range and see if that helps. Also, you can use Insert |
Names to find the name of the table and see if it still points to the proper
range.


"Patti" wrote:

The Vlookup was working fine - and then it stopped working completely. Is
there a refresh or something in the naming of the list?

Why would a vlookup function stop working in excel 2003?
 

Calculation mode was accidentally change to "manual"?

ToolsOptionsCalculation.

Set it to "automatic"



Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 10:21:03 -0700, Patti
wrote:

The Vlookup was working fine - and then it stopped working completely. Is
there a refresh or something in the naming of the list?