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, the MATCH function finds the first value in the lookup_array that is exactly equal to lookup_value. This is also known as an exact match.

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