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)
The nuts and bolts of VLOOKUP
An explanation of each of the function's arguments. (3:04)
Look up values on a different worksheet
How to find values on another worksheet. (2:37)
Copy a VLOOKUP formula
How to use absolute cell references to copy a formula down a column. (3:30)
Inside this course:
More courses available at Microsoft Office Training.