XLOOKUP + IFNA Function in Excel: Syntax, Examples and Free Practice
XLOOKUP + IFNA is an Excel Lookup & Reference function. Wraps XLOOKUP in IFNA to show a clean fallback message when the lookup value isn't found.
XLOOKUP + IFNA syntax
Arguments
lookup_value: Value to search forlookup_array: Range to search inreturn_array: Range to return a value from
When to use XLOOKUP + IFNA
Looking up a customer's account tier without an error appearing for new customers.
Practice XLOOKUP + IFNA online, free
Open the live Excel-style spreadsheet and try XLOOKUP + IFNA yourself. No Excel install or sign-up needed to start.
Practice XLOOKUP + IFNA now →More Lookup & Reference functions
Frequently asked questions
What does the XLOOKUP + IFNA function do in Excel?
Wraps XLOOKUP in IFNA to show a clean fallback message when the lookup value isn't found.
What is the syntax of XLOOKUP + IFNA in Excel?
The syntax is =IFNA(XLOOKUP(lookup_value, lookup_array, return_array), "Not Found"). lookup_value: Value to search for; lookup_array: Range to search in; return_array: Range to return a value from.
Where can I practice XLOOKUP + IFNA online for free?
Open the free live spreadsheet on Cellgrids and try XLOOKUP + IFNA 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