Cell Address

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top