Quick Reference Card: VLOOKUP troubleshooting tips

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.

To view a three-page reference card that offers basic troubleshooting tips for VLOOKUP, click the link below. This card opens as a PDF file in Adobe Reader. Feel free to print a copy of the card, or save it somewhere on your computer to refer to later.

Open the card button

Thumbnail of VLOOKUP Troubleshooting Tips card

Top of Page Top of Page

 
 
Applies to:
Excel 2013, Excel 2010, Excel 2007, Excel 2003