Index match

[surkdidat]

Hopefully someone can help! I have the following formula, but I need to include it to look at the value in column BL for a specific value of "AAA"

=INDEX(Sheet1!$AN$2:$AN$33461,MATCH($A4,IF(Sheet1!$BJ$2:$BJ$33461=L$1,Sheet1!$B$2:$B$33461),0))/100

 

[surkdidat]

Re: INDEX MATCH Help

That all works perfectly. Many thanks

Many thanks, what is the Aggregate "code" for lowest value, just in case I need that in the future please? Can that be used in the same context as below?