Vlookup without other workbook open

cAPSlOCK

New Member
Joined
Aug 26, 2006
Messages
9
Is there a syntax I can use in my formula to reference another workbook using the VLOOKUP function? Excel tells me I have to have the other workbook open in order to retrieve the information. Is there a way around this? Cheers!
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Jeffrey Smith

Well-known Member
Joined
Feb 11, 2005
Messages
795
I created a vlookup to another workbook while it was open. I closed the other workbook and the lookup still worked. I'm working in Excel 2002.

Jeff
 

AussieJac

Board Regular
Joined
Jul 7, 2005
Messages
57
To my knowledge you have to have the other workbook open to set up the formula in the first place but then it will update without the other worksheet being open.

But if you have heaps of these formulas, its better to have the other worksheet open in the background otherwise to takes to long to update.

Of cause if this is a function you perform often you could always use a macro to open and close the other sheet behide the scenes so to speak.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,673
Messages
5,549,355
Members
410,910
Latest member
DessertDiva
Top