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.

VLOOKUP: When and how to use it

The basics of using VLOOKUP. (2:37)

Excel 2013

The nuts and bolts of VLOOKUP

An explanation of each of the function's arguments. (3:04)

Excel 2013

Look up values on a different worksheet

How to find values on another worksheet. (2:37)

Excel 2013

Copy a VLOOKUP formula

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

Excel 2013

Inside this course:

More courses available at Microsoft Office Training.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!