| 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? |
| 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 | |||
Threaded Mode
