VLOOKUP: When and how to use it

VLOOKUP: When and how to use it

Learn how to use the VLOOKUP function to find data in a large spreadsheet, and on other worksheets in a large workbook. These videos explain each of the VLOOKUP arguments, and mistakes to avoid.

Applies to:
File Size:

Inside this course:

VLOOKUP: When and how to use it (2:37)
The basics of using VLOOKUP.

The nuts and bolts of VLOOKUP (3:04)
An explanation of each of the function's arguments.

Look up values on a different worksheet (2:37)
How to find values on another worksheet.

Copy a VLOOKUP formula (3:30)
How to use absolute cell references to copy a formula down a column.

Course summary
A brief reminder of the key points in this course.

More courses available at Microsoft Office Training.