Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset function with nested match function not finding host ss.
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 "MKunert" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF function with 14 nested levels | Excel Worksheet Functions | |||
Complicated Index Match Offset function | Excel Worksheet Functions | |||
Links to 2nd closed worksheet fail when using offset function ?? | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions |