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.
|