Microsoft Excel VLOOKUP troubleshooting tips
APPLIES TO: Excel 2016 , Excel 2013 , Excel 2010 , Excel 2007 , Excel 2016 for Mac
How to Fix Common Excel VLookup Problems Quickly
If you use the VLOOKUP function to look up values in a list or table, it’s possible to end up with #N/A errors, particularly when you’re looking for exact matches. Although these errors are annoying, they occur for a good reason—either the value you’re trying to find doesn’t exist, or it does exist but Excel doesn’t perceive it as a match due to a formatting mismatch or other issue.
Print a copy of the card, or save it somewhere on your computer to refer to later.