MATCH Function
The MATCH function is one of the lookup and reference functions. It is used to return a relative position of a specified item in a range of cells.
Syntax
MATCH(lookup_value, lookup_array, [match_type])
The MATCH function has the following arguments:
Argument |
Description |
lookup_value |
A value in the lookup_array to search for. It can be a numeric, logical or text value, or a cell reference. |
lookup_array |
A single row or column you need to analyze. |
match_type |
A type of match. It's an optional argument. The possible values are listed in the table below. |
The match_type argument can be one of the following:
Numeric value |
Meaning |
1 or omitted |
The values must be sorted in ascending order. If the exact match is not found, the function will return the largest value that is less than lookup_value. |
0 |
The values can be sorted in any order. If the exact match is not found, the function will return the #N/A error. |
-1 |
The values must be sorted in descending order. If the exact match is not found, the function will return the smallest value that is greater than lookup_value. |
Notes
How to apply the MATCH function.
Examples
The figure below displays the result returned by the MATCH function.
Return to previous page