=INDEX(B:B,MATCH(A2&"*",B:B,0))

Looks like it should work.



excelFan wrote:

hi all,
help please
if the ADDRESS of a cell is produced by the formula
=ADDRESS(MATCH(A2&"*",B:B,0),2,4) . Say for example B251 , how can I return
the value of this address.
many thanks

--

Dave Peterson