Based on your example, try this formula in D5:

=CELL("address",OFFSET(A1,MATCH(C5,A2:A4,FALSE),1) )

I'm sure there is an easier or more elegant solution, but this seems
to return the cell address B3 as you requested.

Regards,
Steve Hieb