For which of the following MATCH functions must the values in the lookup_array be ordered in a descending order?
A) When match_type = -1
B) When match_type 1
C) When match_type = 0
D) When match_type = 1

Question

For which of the following MATCH functions must the values in the lookup_array be ordered in a descending order?
A) When match_type = -1
B) When match_type >1
C) When match_type = 0
D) When match_type = 1

Quizplus · Accepted Answer

When match_type = -1, the lookup_array must be sorted in a descending order for the MATCH function to work correctly.

For Which of the Following MATCH Functions Must the Values