In the Excel MATCH function, which argument defines the range of values for which you want to look for a match?
A) Lookup_array
B) Range
C) Array
D) Lookup_value
E) Match_type

Question

Quizplus · Accepted Answer

The argument "Lookup_array" in the MATCH function defines the range of values for which you want to look for a match. This is the range where Excel will search for the "Lookup_value" (specified in a different argument) and return the position of the matching value based on the "Match_type" argument. The other options listed are not relevant to specifying the range of values to search.

In the Excel MATCH Function, Which Argument Defines the Range