Index formula to find student name and max marks

                Index formula to find student name and marks

=INDEX(B6:B14,MATCH(MAX(J6:J14),J6:J14,0))& " MAX MARKS IS = "&MAX(J6:J14)

    Index formula to find student name and sub marks

=INDEX($F$9:$N$18,MATCH($K$21,$G$9:$G$18,0),MATCH(J22,$F$9:$N$9,0))