Excel® 2010 Workbook for Dummies®

Chapter 12. Using Lookup Functions

In This Chapter

• Doing a horizontal lookup in a data table

• Doing a vertical lookup in a data table

• Looking up values in a data table using the Lookup Wizard

The Lookup functions in the Lookup & Reference category of Excel functions are designed to automate the process of matching values in two separate lists or tables in a workbook and then returning a related value. For example, you can set up a price lookup table in a worksheet where you store and update the prices for all the items your company sells. After that, you construct formulas in a sales table using the appropriate lookup function that match an item number entered into a field in the sales table with an item number entered into the price lookup table. When the function finds a match between these item numbers, Excel then copies the price associated with that item number in the price lookup table and pastes it into the appropriate field in the sales table.

The Reference functions are primarily designed to return specific types of information about particular cells or regions of a worksheet. This part of the Lookup & Reference category also includes functions that create hyperlinks to different worksheets and documents and that transpose the data in a table so that data that originally ran across the rows now runs down the columns, and vice versa.

In this chapter, you get a chance to practice creating formulas that automate table lookup, including looking up a single value, either across a row ...