Tip: Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor.

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 download a 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

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

See Also

VLOOKUP function

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×