Quick Reference Card: VLOOKUP troubleshooting tips

If you use the VLOOKUP function to search for specific 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 because of a formatting mismatch or other issue.

To download a three-page reference guide that offers basic troubleshooting tips for VLOOKUP, click the link below. When you click the link, this document will download as a PDF file for viewing in Adobe Reader. You can print a copy of this reference guide, or save it to your computer for future reference.

See Also

Quick Reference Card: VLOOKUP refresher

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

×