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