V Lookups
 

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

V Lookups
 

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

V Lookups
 

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

V Lookups
 

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

V Lookups
 

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 -

V Lookups
 

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 -