Excel VLOOKUP and #N/A

#N/A errors in MS Excel using a VLOOKUP formula can be frustrating. It is actually Excel's way of telling you that the value you are searching for isn't in your table of values. To make it look more appealing use the VLOOKUP together with IFERROR function to return a result such as "Not found" or a blank value.