Which of the following Lookup functions returns the relative position of an item in an array that equals a specified value in a specified order?
A) HLOOKUPlookup_value, table_array, row_index_num)
B) MATCHlookup_value, lookup_array, match_type)
C) INDEXarray, row_num, col_num)
D) VLOOKUPlookup_value, table_array, col_index_num)

Question

Quizplus · Accepted Answer

The MATCH function returns the relative position of an item in an array that matches a specified value. Its syntax is MATCH(lookup_value, lookup_array, [match_type]), where "lookup_value" is the value you want to match in "lookup_array". The "match_type" argument specifies how Excel matches the "lookup_value" with values in "lookup_array".

Which of the Following Lookup Functions Returns the Relative Position