How-to lookup cell address

Question

I'm currently trying to do a lookup, and want to get the address of the result. Let's say A5->A20 contain names and I want to match it with the name in B1.

=cell("address",LOOKUP(B1,A20:A21))

This gives me a N/A. What should I do to get the address as a result?

Answer 1

Try this:

=IFERROR(ADDRESS(MATCH(B1,$A1:$A20,0), 1),"")

NB: 1 hard codes column A.

Answer 2

To find the Address:

="A" & MATCH(B1,A:A,0)