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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
