How to get cell references
 

I have a value in a particular cell and I need to return the cell reference
of that particular cell eg. "A23". What is the function for getting it.

Thanks in advance
Joseph

If cell A23 has a value that you want to use elsewhere then use

=A23

But if A23 has a text string in it like "Z99" that you want, then use

=INDIRECT($A$23)
--
Gary's Student


"Joseph" wrote:

I have a value in a particular cell and I need to return the cell reference
of that particular cell eg. "A23". What is the function for getting it.

Thanks in advance
Joseph

Try

=CELL("address",B3)

where B3 is the cell you want the address for

This will produce $B$3 as the result.


--
SuperDave
------------------------------------------------------------------------
SuperDave's Profile: http://www.excelforum.com/member.php...o&userid=25935
View this thread: http://www.excelforum.com/showthread...hreadid=393272