Match function

Description

This MATCH function could be used to locate the position of a lookup in a row, column or table. Match supports approximate and exact matching. It is possible the INDEX function to be combined with MATCH function to retrieve the value at the position returned by MATCH.

​

Objective

Obtain the position of an item in an array.

​

Syntax

=MATCH(lookup_value,lookup_array,[match_type])

​

Arguements

lookup_value - Value to match in lookup_array.

lookup_array - Range of cells or an array reference.

match_type - [optional] To match, specified as -1, 0 or 1. Default is 1.

​