XMATCH function in Excel

Syntax

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

Example

=INDEX(C2:C6,XMATCH("Monitor",B2:B6)) returns the price of Monitor.

From the lesson XMATCH and INDEX/XMATCH.

Common mistakes

• Expecting XMATCH to return the value: it returns the position.
• Forgetting it needs Excel 2021 or Microsoft 365.

Related lookup functions

• VLOOKUPLooks down the first column of a table and returns a value from another column.
• HLOOKUPLooks across the first row of a table and returns a value from another row.
• XLOOKUPFinds a value in one range and returns the matching item from another.
• MATCHReturns the position of a value in a range.
• INDEXReturns the value at a given row and column of a range.