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

See Also

Quick Reference Card: VLOOKUP refresher

Applies To: Excel 2016 for Mac, Excel 2010, Excel 2013, Excel 2016, Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language