Using the Excel IFNA Function
SummaryThe IFNA function will return a user specified value if a formula returns the #N/A error. If the error is not triggered then the result of the function will be returned. IFNA is a useful function when trying to identify #N/A errors so that they can be corrected, especially when using lookup functions such as VLOOKUP and HLOOKUP. Users should note that IFNA only handles the #N/A error and other errors will still display. A similar function is IFERROR, though this will catch the #N/A and other errors.
Value is a required field and is the argument that checks for the #N/A error.
Value_if_na is also required and is the user specified value that should be returned if the formula returns the #N/A error.
Usage NotesBlank Cells
If the input for value or value_if_na is an empty cell the function will treat this as an empty string value ("").
If the value argument is an array formula the function will return an array of results for each cell in the specified range.