Module Four: Excel Lookup Functions

One of the most common tasks in Excel is the process of looking up specific values within a data set. In a simple database, this process would be completed by writing a query for a specified table. For Excel, you complete this task using a formula which references a data range. In Excel, there are several lookup functions. This module will introduce you to the most common and illustrate how they work.