In this article, we will learn about the IFNA function.
IFNA is a built-in function in Excel. It is categorized as a Logical Function on logic_test. It traps and holds the #NA error and returns the value if error occurs.
IFNA function holds the #NA error and returns value_if_NA error occurs.
Let’s see an example to understand this.
Here we have a list of 5 students with class.
We will look up the class of the student from name using LOOKUP function.
Use this formula to find the Jim’s class
VLOOKUP function looks for the name Jim in the list.
IFNA function works if #NA error occurs and returns Not found if #NA error occurs else returns class of Jim.
It returns Class 1 as Jim’s class.
Now we try to find Mary’s class. Some of you would be wondering Name of Mary is not in the list. Exactly, So LOOKUP function will return #NA error and IFNA function comes in use here.
Use the formula to find Mary’s class
VLOOKUP function looks for the name Mary in the list.
IFNA function works if #NA error occurs and returns Not found if #NA error.
As you can see IFNA holds the #NA error and returns Not found.
Hope you understood how to use the IFNA function. You can use the same functions in Excel 2016, 2013 and 2010. There are more articles on Logic_test. Please do check more links here and if you have any unresolved query, please state that in the comment box below. We will help you.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.