By using Excel IFNA Function you can evaluate a value for #N/A.
If an error occurs you can change it by some specific value or with a more meaningful message and if an error doesn’t occur it will return original value. Unlike IFERROR Function, IFNA test only for #N/A.
In above example, I have used IFNA to deliver a meaningful message for an error. You can use this type of formula to evaluate & specify a particular message against #N/A.
In the below example, I have used IFNA to evaluate #N/A. In VLOOKUP Function #N/A will occur when the lookup value is not in the lookup range and for that I have specified a meaningful message.
Note: IFNA Function is introduced in Excel 2013 so it is not available in previous versions.
To learn more about Excel IFNA Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.