View Single Post
  #1   Report Post  
NewAlgier
 
Posts: n/a
Default 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.