software

How can I retrieve the address of a cell in a A1 format?
Example: I have a cell that has something like 28.010D. How can I use a
formulad to retrieve the reference of that cell in a worksheet, let's say the
cell that contains the 28.010D is the D45. I want to apply a formula so that
the result is D45.
Thank you

Assuming the value you want to look up in column D is in cell A1, then put
this in B1

=quot;Dquot;amp;MATCH(A1,D)

Vaya con Dios,
Chuck, CABGx3
quot;Zambrosioquot; wrote:

gt; How can I retrieve the address of a cell in a A1 format?
gt; Example: I have a cell that has something like 28.010D. How can I use a
gt; formulad to retrieve the reference of that cell in a worksheet, let's say the
gt; cell that contains the 28.010D is the D45. I want to apply a formula so that
gt; the result is D45.
gt; Thank you