How to get cell references

[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

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

[SuperDave]

Try

=CELL("address",B3)

where B3 is the cell you want the address for

This will produce $B$3 as the result.