Formula to return the name of a cell

A

Adresmith

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
 
N

N Harkawat

If you mean cell address by cell name then

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

Domenic

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!
 
Top