UNDERSTAND & FIX EXCEL ERRORS: Download our free pdf
http://www.bluepecantraining.com/course/microsoft-excel-training/
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!/

The #N/A error is actually quite useful - especially when performing a VLOOKUP in Excel. The error tells you a match cannot be found. The video gives some examples where error might occur and shows you how to cloak it using IFERROR
------------------------