What does it mean when the formula result of the MATCH function in Excel equals 2?
A) Two items matched the Lookup_value.
B) The item labeled "2" matched the Lookup_value.
C) The Lookup_value was found in the second position of the Lookup_array.
D) An error occurred.
E) The closest item to the Lookup_value was within two units of that value.

Question

Quizplus · Accepted Answer

The MATCH function in Excel returns the position of a Lookup_value in a Lookup_array. Therefore, if the result of the MATCH function is 2, it means that the Lookup_value was found in the second position of the Lookup_array.

What Does It Mean When the Formula Result of the MATCH