Excel Match

Match Function in Excel is used to get the relative position of a cell in an array or a range that matches a specified value.

Syntax
MATCH (lookup_value, lookup_array, match_type)

Arguments
Lookup_value – This is the value you want to match in lookup_array.
Lookup_array – This is the range being searched.
Match_type – This is an integer: -1 (lookup_array must be in descending order), 0 or 1 (lookup_array must be in ascending order).

-1 – Match finds the position of the smallest value greater than or equal to the lookup_value.
0 – Match finds the position of the first value exactly the same as the lookup_value.
1 – Match finds the position of the largest value greater than or equal to the lookup_value.

Note that if you omit the match_type argument, it is assumed to be 1.