Max Value From Multiple Index Match

[Legacy 396030]

I have this formula array that I want to get the max value from column D when all 3 matches are made:

{=IFERROR(INDEX(D$2:D$12,MATCH(1,($G2=$A$2:$A$12)*($H2=$B$2:$B$12)*($I2=$C$2:$C$12),0)),"")}

Does anyone know how to alter this to get the max value?

Thank you very much in advance for your help

BRS

 

[James006]

Hello,

You could test the following array formula ...

=MAX(IF($A$2:$A$12=$G2,IF($B$2:$B$12=$H2,IF($C$2:$C$12=$I2,$D$2:$D$12))))

HTH

 

[Legacy 396030]

Thank you very much that works!

 

[James006]

Thank you very much that works!

Glad you could fix your problem ... :wink:

Thanks a lot ... for your Thanks ...