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