software

I have an offset function with a nested match function that looks to a
separate spreadsheet. If I have both spreadsheets open, it works fine. If
the host ss is not open, I get a #VALUE! error. The vlookups on the sheet
look to the same host spreadsheet, and they are not affected. Any ideas?

That's the way it is, OFFSET does not work with closed workbooks, if you can
replace with index and match it will workRegards,

Peo Sjoblomquot;MKunertquot; gt; wrote in message
...
gt;I have an offset function with a nested match function that looks to a
gt; separate spreadsheet. If I have both spreadsheets open, it works fine.
gt; If
gt; the host ss is not open, I get a #VALUE! error. The vlookups on the sheet
gt; look to the same host spreadsheet, and they are not affected. Any ideas?