# IFNA Function

How to use the IFNA Function in Excel:

The IFNA Function returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.

In the below example, we are using the VLOOKUP Function in column G to see how many we have of each item.  If no value is found in column B, the formula will return #N/A.
In column G7, we have the following formula: =VLOOKUP(F7,\$B\$5:\$C\$8,2,FALSE)
This formula returns the result #N/A because the formula is looking for the value “Rabbits” found in cell F7, but the value does not find a match in column B

In column H, we are using the IFNA Function along with the VLOOKUP Function.  In this formula, if no value is found in column B the formula will return a zero value.
In column H7, we have the following formula: =IFNA(VLOOKUP(F7,\$B\$5:\$C\$8,2,FALSE),0)
This formula returns the result of zero because the formula is looking for the value “Rabbits”, but we told the formula if no lookup value is found then return zero. 