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

Was this information helpful?

How can we improve it?

How can we improve it?

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

Thank you for your feedback!