MATCH Function

Freeintermediate 15 min4 tasks0/60 pts

MATCH returns the position of a value in a list, not the value itself. Use 0 as the last argument for an exact match. It is the building block for INDEX and for flexible lookups.

Syntax

MATCH(lookup_value, lookup_array, [match_type])

Example: =MATCH("Monitor",B2:B6,0) returns 4 because Monitor is the 4th item in B2:B6.

Common mistakes

Leaving out 0, which gives an approximate match.
Counting from the sheet row instead of from the start of the range.

XLOOKUP & Wildcards MATCH Practice