In the Excel MATCH function, which "Match_type" forces the MATCH function to look for an exact match of Lookup_value in Lookup_array?
A) 10
B) 0
C) -1
D) 1
E) E

Question

Quizplus · Accepted Answer

The "Match_type" of 0 forces the MATCH function to perform an exact match of Lookup_value in Lookup_array. The other "Match_type" options either assume that the Lookup_array is sorted in ascending or descending order, or allow for an approximate match.

In the Excel MATCH Function, Which "Match_type" Forces the MATCH