Adress formula nested in an IF...

  • Thread starter Thread starter SpeeD72
  • Start date Start date
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!
 
-----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
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Address in IF formula.. doens work.. 2
Improving Nested Formula Calculation Efficiency 2
Cell value = adress. How to select in VBA? 5
Extracting a Part of a Formula as Text 5
Problem in Range VBA excell... 5
Array with many cells from a row but not in order or together 11
how ro reference to other sheet with look 1
vArray = Sheet2.Range("A1:A" & lr) troubles ahoy 11

Back
Top