Index(Match...)

[Safak]

Hi all,

I m trying a index(match..) formula with a dynamic range such as :

=INDEX($X$13:$X$88,MATCH(F6,F13:F88,0))

F13 in F13:F88 definition needs to change depending on like F13+n rows

For F13+n rows (assuming F13=Address(13,6) ) I used Address(13+G5,6) where G5 is autocalculated.

But when adapting F13+n rows to index/match formula like

=INDEX($X$13:$X$88,MATCH(F6,​

Address(13+G5,6)​

:F88,0))​

, I receive an error.

May I ask your support on solving this problem ?

thanks in advance

 

[AlanY]

try

=INDEX($X$13:$X$88,MATCH(F6,INDIRECT("F"&13+G5&":F88"),0))

 

[pgc01]

Hi

Try also:

=INDEX($X$13:$X$88,MATCH(F6,INDEX($F:$F,13+G5):F88,0))