XMATCH

Lookup & referenceMicrosoft 365

Modern MATCH — exact by default, reverse search, wildcard and binary modes.

Syntax

XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

Examples

=XMATCH(A2, headers)

→ column position, exact match

Related functions

MATCH XLOOKUP INDEX

More Lookup & reference functions

ADDRESS AREAS CHOOSE COLUMN COLUMNS FORMULATEXT GETPIVOTDATA HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.