MATCH Function

About

The Excel MATCH function can be used to locate the position of a value in Row or Column.

MATCH function is often combined with INDEX function to retrieve the value from a matched position and is a powerful VLOOKUP alternative.

Function Type

Lookup and reference

Purpose

Get the position of an item from a list or an array of values.

Return value

Number representing position of the searched item.

Syntax

=MATCH (lookup_value, lookup_array, [match_type])

Arguments

look_value – The value to search for.

look_array – The array or table in which lookup_value is searched.

match_type – [optional] 1 for exact or next smallest, 0 for exact match, -1 = exact or next largest. 1 is the default value.


Examples


Notes

MATCH function returns #N/A error if no match is found.

MATCH function is not case-sensitive.

In case of duplicates, MATCH function returns the first match.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel