In Excel, what are the three arguments that a MATCH function takes?
A) Lookup_value, Match_type, and Lookup_array
B) Lookup_value, Match_type, and Array
C) Lookup_value, Column_num, and Lookup_array
D) Array, Row_num, and Column_num
E) Lookup_array, Row_num, and Column_num

Question

Quizplus · Accepted Answer

The MATCH function in Excel takes three arguments: Lookup_value (the value you want to search for), Match_type (specifies how the lookup value should be matched with the lookup array), and Lookup_array (the range of cells you want to search in). Choice A correctly identifies these three arguments.

In Excel, What Are the Three Arguments That a MATCH