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

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

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

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

"Sue T" wrote in message ...
|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 message ...
| | 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
|
|
|

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 -

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

"Pete_UK" wrote:

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 -