What is the purpose of the Row_num argument in the following INDEX function?
=INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)
A)To return the highest value in the range B2:B5
B)To return the position of the highest value in the range B2:B5
C)To return the column to the left of the highest values in the range B2:B5
D)To return the row of the highest value in the range B2:B5

Question

What is the purpose of the Row_num argument in the following INDEX function? 
=INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)
A)To return the highest value in the range B2:B5
B)To return the position of the highest value in the range B2:B5
C)To return the column to the left of the highest values in the range B2:B5
D)To return the row of the highest value in the range B2:B5

Quizplus · Accepted Answer

The Answer of What is the purpose of the Row_num argument in the following INDEX function? 
=INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)
A)To return the highest value in the range B2:B5
B)To return the position of the highest value in the range B2:B5
C)To return the column to the left of the highest values in the range B2:B5
D)To return the row of the highest value in the range B2:B5

What Is the Purpose of the Row_num Argument in the Following