VLOOKUP: When and how to use it

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.

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.

Applies To: Excel 2013



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