Why would a vlookup function stop working in excel 2003?

[Patti]

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

 

[PJFry]

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

 

[JLatham]

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.

 

[Gord Dibben]

Calculation mode was accidentally change to "manual"?

Tools>Options>Calculation.

Set it to "automatic"



Gord Dibben MS Excel MVP