In a MATCH function, if the match_type = 0, then .
A) the function finds the largest value that is less than or equal to lookup_value
B) the function finds the smallest value that is greater than or equal to lookup_value
C) MATCH finds the first value that is exactly equal to lookup_value
D) the values in the lookup_array must be in a particular order

Question

Quizplus · Accepted Answer

When match_type = 0 in the MATCH function, it searches for the first value that is exactly equal to the lookup_value, regardless of the order of the data in the lookup_array.

In a MATCH Function, If the Match_type = 0, Then