Question: Why would you nest MATCH in an INDEX function? A ) To handle multiple outcomes B ) To find the highest or lowest value in

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!