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.

Goals

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)

Practice

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.

Applies To: Excel 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language