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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!