Spreadsheets: Using the VLOOKUP function

Learning Objectives

  • Use the VLOOKUP function to find exact data
  • Use the VLOOKUP function to find approximate data
  • Use the VLOOKUP function across worksheets
  • Use an absolute reference in a VLOOKUP function

Prerequisite Skills

  • Use formulas and functions
  • Create and use absolute cell references
  • Create and use named ranges

Expand Course Available

View Course in Expand

More information about this course

This online course is free to everyone and available for enrollment through IU Expand.

This course consists of a series of short lessons, examples, demonstrations, practice quizzes, and hands-on exercises.

To complete the course content, you will need:

  • a web browser and internet access to use the course material on IU Expand.
  • a copy of the software relevant to the training installed on your computer.