XMATCH Function in Excel: Syntax, Examples and Free Practice
XMATCH is an Excel Lookup & Reference function. The modern replacement for MATCH — more flexible matching and search options.
XMATCH syntax
Arguments
lookup_value: The value you are searching forlookup_array: The range to search withinmatch_mode: How closely the value must match (optional)search_mode: Which direction to search in (optional)
When to use XMATCH
XMATCH is used to pull matching data from one part of a workbook into another.
Practice XMATCH online, free
Open the live Excel-style spreadsheet and try XMATCH yourself. No Excel install or sign-up needed to start.
Practice XMATCH now →More Lookup & Reference functions
Frequently asked questions
What does the XMATCH function do in Excel?
The modern replacement for MATCH — more flexible matching and search options.
What is the syntax of XMATCH in Excel?
The syntax is =XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]). lookup_value: The value you are searching for; lookup_array: The range to search within; match_mode: How closely the value must match (optional); search_mode: Which direction to search in (optional).
Where can I practice XMATCH online for free?
Open the free live spreadsheet on Cellgrids and try XMATCH yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts