INDEX + MATCH(MAX) formula issue

Hi,

Try this formula in cell U10:

Formula:

=INDEX($A$1:$A$28,SUMPRODUCT((--($G$6:$G$28=$V$10))+(--($K$6:$K$28=$V$10))+(--($O$6:$O$28=$V$10)),ROW($A$6:$A$28)))

I hope this helps