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.
A brief reminder of the key points in this course.
More courses available at Microsoft Office Training.