Video: VLOOKUP—What it is, and when to use it

• • 
  • 3:59
  • Introduction to VLOOKUP
• • 
  • 5:37
  • How, and when, to use VLOOKUP
• • 
  • 5:32
  • Using more than one spreadsheet with VLOOKUP
• • 
  • 3:45
  • Using absolute cell references with VLOOKUP
• • 
  • 5:41
  • Avoiding VLOOKUP errors

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.

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.