Adress formula nested in an IF...
-----Original Message-----
Hi
I´ve made an adress formula in an IF, to return the valeu
of that same cell but in Sheet2. It doesn´t work! the if
formula doesn´t interpert the return of the adress
formula as an excel "range".
Speed
Without the error checking
=INDIRECT(A7&ADDRESS(ROW(),COLUMN())) seems to work.
Regards
Peter
|