Dynamic cell reference using INDIRECT..
wrote...
Is there a way to take this formula "=INDIRECT("'"&$P$3&"'!X9")" and
make X9 dynamic upon copying to other cells? For P3 I only need to
remove the $'s.
=INDIRECT("'"&$P$3&"'!"&CELL("Address",X9))
or if you want it internationalization-safe,
=INDIRECT(ADDRESS(ROW(X9),COLUMN(X9),,,$P$3))
|