Offset function with nested match function not finding host ss.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 work


Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting if functions 1
Offset/match returns #value error 8
Nested IF Functions with OFFSET 3
Arrayformulas with either/or nested to sumproduct if eitherconditions are true 13
match function with nested if 12
Lookup Need Help fast 2
Offset Reference Cell 1
CONCATENATE & LOOKUP Functions 0

Back
Top