Linked spreadsheet help

[floricita]

So I am looking up some figures from another spreadsheet.

When both spreadsheets are open the numbers appear.

But if I close the one that it is looking up from, the next time I open it I get N/A values.

Is there anyway to link the spreadsheets without having to have them both open all the time please?

[lokicl]

Hi,

Basically - if the dependent spreadsheet is in the same location as referred earlier it should workfine, else you will be getting the "N/A" values.
Check in the formula - is the speardsheet is available in the same location.
My suggestion - use the linked spreadsheet method if you have both of them saved in your local disk.

Regards,
lokicl

[floricita]

How can you do the linked spreadsheet when it is a vlook up though? It doesn't work