Return the position of a value within a row or column.
Syntax
MATCH(lookup_value, lookup_array, [match_type])Arguments
lookup_valuerequired
The value whose position you want.
lookup_arrayrequired
The single row or column to search.
match_typeoptional
0 exact, 1 less than, -1 greater than.
MATCH searches for a value and returns its relative position (a number), not the value itself. It's most useful inside INDEX, where the position becomes the row or column to return. Use match_type 0 for exact matches.
=MATCH("A102", A2:A100, 0)→37A102 is the 37th item in the range.
=MATCH("Price", A1:D1, 0)→3Finds which column header is "Price".
Pick the value to locate
Choose the key whose position you need.
Search one row or column
MATCH works on a single vector, not a 2D table.
Use 0 for exact
Pass 0 as match_type unless your data is sorted and you want a range match.
The position — a number. To get the value at that position, wrap it in INDEX.