| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Offset, indirect, match function limitation on linked worksheets.
All of these three functions (offset, indirect, and match) seem to work only
if the linked worksheet is open. Since Vlookup and Hlookup work on closed worksheets, I wonder if anybody has found a workaround for match and offset. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) | |||
| Linked worksheets | Excel Discussion (Misc queries) | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
| Function to operate on ink linked to cell | Excel Worksheet Functions | |||
| Indirect references in a linked formula | Excel Worksheet Functions | |||
Threaded Mode
