Learn how to use VLOOKUP to look up a value you want to find in an Excel list or table. Using VLOOKUP is similar to looking up a person’s name in a telephone book to get a telephone number. VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.
After completing this course you will be able to:
Enter VLOOKUP arguments in a formula.
Use VLOOKUP to find values in Excel lists or tables.
Avoid VLOOKUP errors.
Before you begin
You should already be familiar with Excel formulas. If you are not, take this course: Get to know Excel 2010: Create formulas.
Download this course
Offline version (31 MB)
We’re sorry, the practice session is not available.
Quick reference card
See the quick reference card for a brief, printable reminder of the key points in this course.
See more courses on Microsoft Office Training.