Here is a quick guide to the Microsoft Excel VLOOKUP Function
APPLIES TO: Excel 2016 , Excel 2010 , Excel 2007
VLOOKUP is one of the most popular, useful functions in Excel, but it can be 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.
See also: Troubleshooting VLookup Functions
And browse our Microsoft Excel Course Outlines to find the right training course for you.