MATCH Function in Excel: Syntax, Examples and Free Practice
MATCH is an Excel Lookup & Reference function. Finds the position of a value within a range — usually paired with INDEX.
MATCH syntax
Arguments
lookup_value: Value to search forlookup_array: Range to search inmatch_type: 0 for exact match
When to use MATCH
Finding exactly where a value sits in a list, so INDEX can pull the matching row.
Practice MATCH online, free
Solve graded MATCH practice questions in a live Excel-style spreadsheet and check your answer instantly.
Practice MATCH now →Learn more
Read the tutorial: How to use INDEX and MATCH.
MATCH practice questions
- Using MATCH, find the position of Pune in the city list and put it in D2.
- Find the position of the code typed in E2 in the code list and put it in F2.
- Using MATCH, find at which position the student who scored exactly 78 appears and put it…
- The slab starts are sorted from small to large. Using MATCH with an approximate match,…
- The pass marks are listed from highest to lowest. Using MATCH with match type -1, find…
- Using MATCH with a wildcard, find the position of the first product whose name starts…
- Find which column number (counting from January as 1) March is in, using MATCH on the…
- Using MATCH with MAX, find the position of the highest mark in the list and put it in D2.
- Check whether the invoice number typed in E2 is in the list. Show Found if it is and…
- The Cumulative column only goes up. Using MATCH with approximate match, find the…
More Lookup & Reference functions
Frequently asked questions
What does the MATCH function do in Excel?
Finds the position of a value within a range — usually paired with INDEX.
What is the syntax of MATCH in Excel?
The syntax is =MATCH(lookup_value, lookup_array, [match_type]). lookup_value: Value to search for; lookup_array: Range to search in; match_type: 0 for exact match.
Where can I practice MATCH online for free?
Open the free live spreadsheet on Cellgrids and try MATCH 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