The MATCH function will return a value of 1 if the given lookup_value is the largest number in an array of numbers.

Name: The MATCH function will return a value of 1 if the given lookup_value is the largest number in an array of numbers.
Brand: Quizplus
Rating: 4.9 (32 reviews)

Question

Quizplus · Accepted Answer

The MATCH function will return the position of the lookup_value in the array. If the lookup_value is the largest number in the array, it will be in the last position and the MATCH function will return the value 1.

The MATCH Function Will Return a Value of 1 If