Vlookup without other workbook open

[cAPSlOCK]

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!

 

[Jeffrey Smith]

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]

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.