Quick Reference Card: VLOOKUP refresher

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

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

.

 
 
Applies to:
Excel 2010, Excel 2007, Excel 2003