=INDEX(A2:
B5,MATCH(MAX(B2:
B5),B2:
B5,0),1)is an example of a nested function.

Name: =INDEX(A2: B5,MATCH(MAX(B2: B5),B2: B5,0),1)is an example of a nested function.
Brand: Quizplus
Rating: 4.8 (31 reviews)

Question

Quizplus · Accepted Answer

The formula uses the INDEX and MATCH functions together. The MATCH function finds the position of the largest value in the range B2:B5, and this position is used as the row argument in the INDEX function to return the corresponding value in column 1 (which is A). This combination of functions is an example of a nested function.