# IFNA Function

The Excel IFNA function returns a user-defined value if a formula results in an #N/A (value not found) error.

IFNA is a part of the logical functions and compatible with Excel 2013 and above.

## How to use IFNA Function in Excel?

As stated above, the main goal of using the IFNA function is to replace the built-in #N/A error with a descriptive, user-friendly output.

Using the IFNA function, you can manage #N/A errors and create easy-to-understand output. If you are working with lookup functions, especially VLOOKUP and HLOOKUP.

### Syntax and arguments

=IFNA (value, value_if_na)

The function uses two arguments:

• value – The result of the formula if the result is a value
• value_if_na – The user-defined value if the function returns with an #N/A error

### Trap and handle #N/A errors

In the example, we’ll use the classic VLOOKUP function.

To simplify the table containing products and prices, use a named range for the B3:C8 range. Add the name ‘data’ for the range.

Type the following formula in cell F5:

As you see in the picture below, VLOOKUP gets the prices for Product 3 and Product 4. What if the source range does not contain Product 11? Begin the expression with the IFNA function. The first argument is the VLOOKUP function. Add a “Not found” string as a second argument to manage errors.

In the next chapter, we will take a closer look at an error handling solution without using the IFNA function.

### Error handling without IFNA function

Are you Microsoft 365 user? We have a piece of great news:

Tip: if you are using XLOOKUP, no additional error-handling function is required. The 4th argument of the function helps you to produce an error-free output in case of any errors.

### Differences between IFERROR and IFNA functions

You can use the IFNA function to manage only the #N/A errors if you have other errors like #REF, #DIV/0! We recommend you use the IFERROR function.

In the picture below, you can compare how these functions work. To calculate the average sales price, apply the formula in column F:

=D3/C3

=in cell E6, the formula returns with a #DIV/0! error. In cell G6, IFERROR can manage the output and returns with the user-defined “error” string. The result is the same if you are looking for the #VALUE! error in cell E7.

### Other error functions

If you are working with formulas, you’ll face various types of errors, not just #N/A. Keep in mind that the IFNA function only handles the #N/A error.

Here is the list of other error-handling functions in Excel:

• ISNA function returns TRUE for #N/A errors only.
• ISERROR function returns TRUE for any error.
• ERROR.TYPE function returns a code to identify the error. Istvan Vozar

Istvan is the co-founder of Visual Analytics. He helps people reach the top in Excel.