Excel IFNA function
In Excel, the IFNA function returns a custom result when a formula generates the #N/A error, if no error is detected, the normal result will be returned.
The syntax for the IFERROR function in Excel is:
Returns the specific value for the #N/A errors.
In this example, we will use the IFNA function with a VLOOKUP function. If the lookup data is not found from the table, an error of #N/A is displayed, to fix the error value, you can combine the IFNA function.
Now, if you want to find the corresponding Order based on the Product, the normal Vlookup formulas can help you: =VLOOKUP(D2,$A$2:$B$8,2,FALSE), if the value not found from the vlookup table, an error value is returned.
To fix this #N/A error value, you can combine the IFNA function with the Vlookup formula as this: