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 MATCH function assumes that the lookup_array is sorted in descending order. This is used to find the smallest value that is greater than or equal to the lookup_value.

For Which of the Following MATCH Functions Must the Values