return valuve
thanks Dave, works fine
"Dave Peterson" wrote:
=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
|