I am trying to write a formula that will look at a cell and if it is not
blank then it will return the cell name (rather than the cell value).
Any help would be greatly appreciated!

Thanks!
Adrianne


--
Adresmith
------------------------------------------------------------------------
Adresmith's Profile: http://www.excelforum.com/member.php...fo&userid=9131
View this thread: http://www.excelforum.com/showthread...hreadid=379077

If you mean cell address by cell name then

=IF(ISBLANK(A1),"",CELL("ADDRESS",A1))
will return $A$1 if A1 is not blank.


"Adresmith" wrote
in message ...

I am trying to write a formula that will look at a cell and if it is not
blank then it will return the cell name (rather than the cell value).
Any help would be greatly appreciated!

Thanks!
Adrianne


--
Adresmith
------------------------------------------------------------------------
Adresmith's Profile:
http://www.excelforum.com/member.php...fo&userid=9131
View this thread: http://www.excelforum.com/showthread...hreadid=379077

Try...

=IF(A1<"",CELL("address",A1),"")

...which will return $A$1, or try...

=IF(A1<"",ADDRESS(ROW(A1),COLUMN(A1),4),"")

...which will return A1.

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=379077