NewAlgier wrote..
All of these three functions (offset, indirect, and match) seem t wor
only if the linked worksheet is open. Since Vlookup and Hlooku wor
on closed worksheets, I wonder if anybody has found a workaroun fo
match and offset
MATCH works with references into closed workbooks, at least as i
formulas lik
=MATCH(A1,'C:\foo\Sheet1'!$A$1:$A$16,0
OFFSET and INDIRECT only work for references into open workbook
because both return range objects, and technically speaking, range
(as in Excel Range objects) exist *only* in *open* workbooks
There's no easy replacement for OFFSET into closed workbooks
Depending on what you're trying to do with the resulting arra
(multiple cell references into closed workbooks are explicitl
returned as array, not as ranges that are implicitly converted int
arrays when used as arrays) there may be work-arounds
As for INDIRECT, if you're trying to create dynamic references int
closed workbooks, se
http://groups-beta.google.com/group/microsoft.public.excel.worksheet.functions/msg/ac443753560f007
(or
http://tinyurl.com/4ms2m
Note that Google is apparenly trying to make the newsgroup archive
more difficult to reference. Gone is the simplicity of using
messages Message-ID tag in the Google url. You'll now have to us
Google's own message ID
