Value errors in a lookup function occur either if there is a value error in
the list itself or if you calculate with the lookup function. Does your
client use the looked up value in a calculation then the lookup value is
text (or the other value is text) if not another formula created the value
either in the lookup table itself or as part of the same formula that holds
the lookup. I have never had any problems with errors using the same raw
data between different excel versions,
if somehow this only happens in 2003 I assume that somehow it was converted
to text, also make sure your client has the latest service pack installed

note that the =TRUE is not necessary, if ISERROR is TRUE you don't have to
test for it with =TRUE

--
Regards,

Peo Sjoblom

(No private emails please)


"Nick Ersdown" wrote in message
...
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