Video: 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.

Discover more Excel training at LinkedIn Learning

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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.