Return the position of a value within a row or column.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
MATCH(lookup_value, lookup_array, [match_type])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)Result: 37
A102 is the 37th item in the range.
=MATCH("Price", A1:D1, 0)Result: 3
Finds which column header is "Price".
The position — a number. To get the value at that position, wrap it in INDEX.