INDEX + MATCH with wildcards Function in Excel: Syntax, Examples and Free Practice
INDEX + MATCH with wildcards is an Excel Lookup & Reference function. Uses wildcard characters inside MATCH to find a partial text match instead of requiring an exact match.
INDEX + MATCH with wildcards syntax
Arguments
return_range: Range to pull the result frompartial_text: Part of the text to search forlookup_range: Range to search in
When to use INDEX + MATCH with wildcards
Finding a customer record when you only remember part of their company name.
Practice INDEX + MATCH with wildcards online, free
Open the live Excel-style spreadsheet and try INDEX + MATCH with wildcards yourself. No Excel install or sign-up needed to start.
Practice INDEX + MATCH with wildcards now →More Lookup & Reference functions
Frequently asked questions
What does the INDEX + MATCH with wildcards function do in Excel?
Uses wildcard characters inside MATCH to find a partial text match instead of requiring an exact match.
What is the syntax of INDEX + MATCH with wildcards in Excel?
The syntax is =INDEX(return_range, MATCH("*"&partial_text&"*", lookup_range, 0)). return_range: Range to pull the result from; partial_text: Part of the text to search for; lookup_range: Range to search in.
Where can I practice INDEX + MATCH with wildcards online for free?
Open the free live spreadsheet on Cellgrids and try INDEX + MATCH with wildcards 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