#VALUE! error: vlookup works in Excel 2000 but not 2003
Hi,
My client has a spreadsheet which works fine in Excel 2000 but when opened
with Excel 2003 it populates the pages with #VALUE! and the best I can tell
is that the problem is with the following formulas.
Can anyone advise if they have seen this before. I am unable to post their
file but this is the code that I think is a bit suspect.
=IF(ISERROR(VLOOKUP(B14,'C:\Documents and Settings\User\My Documents\[Price
List 040301.xls]Items'!$A:$M,11,FALSE))=TRUE,"",VLOOKUP(B14,'C:\Do cuments
and Settings\User\My Documents\[Price List
040301.xls]Items'!$A:$M,11,FALSE))
Many thanks,
Nick Ersdown
|