V Lookups

[Sue T]

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

 

[Niek Otten]

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


| 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

 

[Sue T]

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]

What is your data, *your formula*, what result did you expect

Is the data sorted? Did you leave out the 4th argument of the VLOOKUP? What column# did you use? etc

Please give your data and formula!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
| >
| >
| > | 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
| >
| >
| >

 

[Pete_UK]

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

 

[Sue T]

Thank you for you help, but the reference is correct.

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

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.








- Show quoted text -