Page 1 of 9PREVNEXT

VLOOKUP: What it is, and when to use it

Judi Hurlock
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.
By Judi Hurlock, Senior Writer

About this course

This course includes:

  • One self-paced lesson.
  • One practice session for hands-on experience. The practice requires Excel 2010.
  • A short test at the end of the lesson. The test is not scored.
  • A Quick Reference Card you can print at the end of the course.


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.

Page 1 of 9PREVNEXT