Excel 2013 Tutorial - How to Hide Errors Returned by Lookup Functions
In this tutorial you will learn :
How to hide errors returned by lookup functions.
The #N/A error is useful in excel models because it alerts you when a match couldn't be found.
But if you have many #N/A your excel document may look ugly. In order to hide those errors we will use the ISNA function.