Help With ADDRESS Function

  • Thread starter Thread starter Tiziano
  • Start date Start date
T

Tiziano

I have the following formula:
=if(Sheet1!$c3<>"", do something, do something else)
that I would like to re-write as:
=if(address(3,3,2,TRUE,"Sheet1")<>"", do something, do something else)

The second formula unfortunately always seems to evaluate to TRUE.

What am I doing wrong?
 
that I would like to re-write as:
=if(address(3,3,2,TRUE,"Sheet1")<>"", do something, do something else)
Click to expand...

WHY?

If you want that way then try like this:

=IF(INDIRECT(ADDRESS(3,3,2,TRUE,"Sheet1"))<>"","do something","do something
else")
 
WHY?

If you want that way then try like this:

=IF(INDIRECT(ADDRESS(3,3,2,TRUE,"Sheet1"))<>"","do something","do something
else")
Click to expand...

Thanks for your suggestion!

You want to know why... Well, the original formula (located on Sheet2
and copied all the way down from A3 to A5000) is linked to a spreadsheet
located on Sheet1. Unfortunately, every time that I delete a row from
Sheet1, I get the dreaded #REF!. So, I am simply trying to find a way
to get around this problem by re-writing my formula as the deletion of
rows on Sheet1 is unavoidable...

If anybody has a better solution...
 
Hi,

If you told us your goal we might be able to give you a better solution.
Why do you want to write it this way?

Although the function is called Address it actually returns a text type not
a reference type result. Therefore would use it with INDIRECT or just try a
different approach.

=IF(INDIRECT("Sheet1!C"&ROW(A3))<>"","something","blank")

and here is a second idea

=IF(OFFSET(Sheet1!A1,2,2)<>"","something","blank")
 
Back
Top