In a MATCH function, if match_type = 1, then the function finds the smallest value that is greater than or equal to lookup_value.

Name: In a MATCH function, if match_type = 1, then the function finds the smallest value that is greater than or equal to lookup_value.
Brand: Quizplus
Rating: 4.8 (34 reviews)

Question

Quizplus · Accepted Answer

When match_type = 1, the MATCH function finds the largest value that is less than or equal to the lookup_value in an array that is sorted in ascending order.

In a MATCH Function, If Match_type = 1, Then the Function