n Excel, the
Match function searches for a value in an array and returns the relative position of that item. The syntax for the
Match function is:
Match( value, array, match_type )
value is the value to search for in the
array.
array is a range of cells that contains the
value that you are searching for.
match_type is optional. It the type of match that the function will perform. The possible values are:
match_type Explanation 1
(default) The Match function will find the largest value that is less than or equal to value. You should be sure to sort your array in ascending order. If the match_type parameter is omitted, the Match function assumes a match_type of 1.
0 The Match function will find the first value that is equal to value. The array can be sorted in any order. -1 The Match function will find the smallest value that is greater than or equal to value. You should be sure to sort your array in descending order.