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