INDEX + MATCH + IFERROR Function in Excel: Syntax, Examples and Free Practice
INDEX + MATCH + IFERROR is an Excel Lookup & Reference function. Wraps an INDEX+MATCH lookup in IFERROR so a missing value shows a clean message instead of #N/A.
INDEX + MATCH + IFERROR syntax
Arguments
return_range: Range to pull the result fromlookup_value: Value to search forlookup_range: Range to search in
When to use INDEX + MATCH + IFERROR
Looking up an employee's manager without the sheet breaking when someone isn't in the list.
Practice INDEX + MATCH + IFERROR online, free
Open the live Excel-style spreadsheet and try INDEX + MATCH + IFERROR yourself. No Excel install or sign-up needed to start.
Practice INDEX + MATCH + IFERROR now →More Lookup & Reference functions
Frequently asked questions
What does the INDEX + MATCH + IFERROR function do in Excel?
Wraps an INDEX+MATCH lookup in IFERROR so a missing value shows a clean message instead of #N/A.
What is the syntax of INDEX + MATCH + IFERROR in Excel?
The syntax is =IFERROR(INDEX(return_range, MATCH(lookup_value, lookup_range, 0)), "Not Found"). return_range: Range to pull the result from; lookup_value: Value to search for; lookup_range: Range to search in.
Where can I practice INDEX + MATCH + IFERROR online for free?
Open the free live spreadsheet on Cellgrids and try INDEX + MATCH + IFERROR 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