| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userforms in Excel 2003 created in Excel 2000 | Excel Discussion (Misc queries) | |||
| Excel 2000 Cannot find Outlook 2003 | Setting up and Configuration of Excel | |||
| Works 4.0(wks) needs to be converted to Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2000 to Excel 2003.... is it worh it? | Excel Discussion (Misc queries) | |||
| How to send Excel 2000 worksheets to Excel 2003? | Excel Discussion (Misc queries) | |||
Threaded Mode
