VLOOKUP: What it is, and when to use it

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!