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

="D"&MATCH(A1,D:D)

Vaya con Dios,
Chuck, CABGx3



"Zambrosio" wrote:

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