by Sisyphus » Sun Apr 01, 2012 11:12 pm
Hi,
This seems to be an Excel version problem as opposed to one of VLOOKUP.
I would guess that you are trying to run an Excel sheet that was prepared in an earlier version of Excel on Excel 2010. For some reason VLOOKUP isn't aware of the transition and tries to read the sheet by its own rules. Now the question is if VLOOKUP is using 2010 rules on a sheet that thinks it is 1997 or is it the other way around?
- I would try to isolate the two problems. Create a new workbook in Excel 2010. Copy the worksheet in question into this workbook by various ways until you feel sure that it is now of 2010 version.
- Delete and re-write the VOOKUP formula in one of the cells where it occurs. The idea would be that Excel 2010 would use a 2010 library to create a new VLOOKUP. That new formula should behave different from any which are confused.
If the above doesn't work I would try to import the sheet into 2010 without the VLOOKUP. This, with the idea in mind that the presence of VLOOKUP in the worksheet might work to prevent a clean transition between versions.
Have a great day!
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)