» Returning the Entire Contents of the Row Containing the Highest Math Grade
Each row of columns B:E contains data on a student's ID, year, subject, and grade.
We want to find the highest math mark in the data range and retrieve all the information from that particular row.
Use the INDEX, MATCH, and MAX functions as shown in the following Array formula:
Copy the formula from cell B8 to cells C8:E8.