How to get cell references

J

Joseph

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
 
G

Gary's Student

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)
 
S

SuperDave

Try

=CELL("address",B3)

where B3 is the cell you want the address for

This will produce $B$3 as the result.
 
Top