Formula to return the name of a cell
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 |
All times are GMT +1. The time now is 12:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com