Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud
Try in the cloud

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.

MATCH Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action