Why would you nest MATCH in an INDEX function?
A)To handle multiple outcomes
B)To find the highest or lowest value in an array
C)To use the position returned in the Match function as an argument in the index function
D)To use the value returned in the Match function as a lookup in the index function

Question

Quizplus · Accepted Answer

Nesting a MATCH function within an INDEX function can be useful when you want to use the result of the MATCH function, which identifies the position of a value within an array, as the row or column argument in the INDEX function. This allows you to retrieve the value of interest from the array.

Why Would You Nest MATCH in an INDEX Function