A
anar_baku
Hi,
Is it possible to make Array References dynamic?
For example I have a formula which is something like this:
=VLOOKUP(A1, [excelFile.xls]*sheetTab*!A1:C10, 2, FALSE)
Is it possible for the value of *sheetTab* in above to depend on the
value of a cell?
So instead of above, I would have something like this:
=VLOOKUP(A1, [excelFile.xls]*A2*!A1:C10, 2, FALSE)
Obviously this formula doesn't work, but hopefully I got my point
accross.
Thanks in advance
Is it possible to make Array References dynamic?
For example I have a formula which is something like this:
=VLOOKUP(A1, [excelFile.xls]*sheetTab*!A1:C10, 2, FALSE)
Is it possible for the value of *sheetTab* in above to depend on the
value of a cell?
So instead of above, I would have something like this:
=VLOOKUP(A1, [excelFile.xls]*A2*!A1:C10, 2, FALSE)
Obviously this formula doesn't work, but hopefully I got my point
accross.
Thanks in advance