Formula to return the name of a cell

  • Thread starter Thread starter Adresmith
  • Start date Start date
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
 
If you mean cell address by cell name then

=IF(ISBLANK(A1),"",CELL("ADDRESS",A1))
will return $A$1 if A1 is not blank.
 
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!
 
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

Excel formula, sum the value cell and if empty cell left blank 0
Help needed 0
return a formula instead of a value of a cell 4
Blank cells in a formula 2
need formula returning a blank cell 4
formula error 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Formula help 1

Back
Top