Adress formula nested in an IF...

S

SpeeD72

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".
Can anyone help me?
Thanks
Speed

=IF((ADDRESS((ROW());(COLUMN());;;A1))<>"";COLUMN();"")

A1 =Sheet2!
 
P

Peter Atherotn

-----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
Click to expand...
formula as an excel "range".

Speed

Without the error checking
=INDIRECT(A7&ADDRESS(ROW(),COLUMN())) seems to work.

Regards
Peter
 
T

Tom Ogilvy

You received an answer to your original question. Why not check it out.

--
Regards,
Tom Ogilvy

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".
Can anyone help me?
Thanks
Speed

=IF((ADDRESS((ROW());(COLUMN());;;A1))<>"";COLUMN();"")

A1 =Sheet2!
 
Top