Perhaps your formula is refering to [filename.xls]Sheet1 etc, but you
have now converted the file so it should be [filename.xlsx]Sheet1 ...
or vice-versa.

Hope this helps.

Pete

On Oct 30, 1:26 pm, Sue T wrote:
I am getting #NA as an answer and it should be a description of a machine
that goes with the # of a mold. Could it be that the lookup workbook and the
other workbook are both not excel 2007. One is a 2003 workbook.



"Niek Otten" wrote:
AFAIK nothing has changed in the VLOOKUP function

What is your data, your formula, what result did you expect and what did you get instead?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sue T" wrote in ...
| Hi - A few months back we were switched to Excel 2007 from 2003. I am having
| a very difficult time keeping my vlookups working. I have the lookup tables
| in the same workbook where they are needed, but sometimes they just won't
| work. I go over the formula again and again, but no luck. Is there
| something in Excel 2007 that has a quirk in it. Some files worked fine after
| the switch and now the lookups won't work at all.. And no -- nothing has
| changed in the vlookup tables. Thanks for you help- Hide quoted text -

- Show quoted text -