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

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×