Thread: Offset function with nested match function not finding host ss.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MKunert
 
Posts: n/a
Default Offset function with nested match function not finding host ss.
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?
Reply With QuoteReply With Quote