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.