Adress formula nested in an IF...
 

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!

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

Adress formula nested in an IF...
 

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

--
Regards,
Tom Ogilvy

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

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

A1 =Sheet2!