| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#REF! error with Multiple Documents
I keep receiving a #REF! error when I try to use VLOOKUP to find data in one
document and bring it to another. If both documents are open all the numbers are fine. However when I close the book with the data I receive the error, or when the vlookup book is opened it does it. If tell it to update the data error, if I don't update error. What is weird is I have other documents that work fine, with the same equation. Please help because I'm lost on this issue. Happens Excel 2007 and 2010. =VLOOKUP(A2,'C:\Users\USER\Documents\BOOK DATA.xlsx'!Data[#All],2,FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
| Multiple documents open, but only seeing one | Excel Discussion (Misc queries) | |||
| how do I converting multiple documents into one? | Excel Discussion (Misc queries) | |||
| Error: Cannot open two documents with the same name | Excel Discussion (Misc queries) | |||
| Error prompt when opening Excel documents. | Excel Discussion (Misc queries) | |||
Threaded Mode
