Quick Reference Card: VLOOKUP refresher

VLOOKUP is one of the most popular, useful functions in Excel, but it’s hard to remember the formula if you don’t use it that often.

If all you want is the syntax for VLOOKUP, here it is:

VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

To view a two-page reference card that explains what the arguments mean and how to use them, click the link below. The VLOOKUP reference 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 QRC Refresher card



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!