return valuve

E

excelFan

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
 
B

Biff

Hi!

Either:

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

=INDIRECT(ADDRESS(MATCH(A2&"*",B:B,0),2,4))

Biff
 
T

Tom Ogilvy

Some others

=Indirect(ADDRESS(MATCH(A2&"*",B:B,0),2,4))

or
=Offset($B$1,MATCH(A2&"*",B:B,0)-1,0)
 
Top