Chapter 12
Using Lookup Functions
IN THIS CHAPTER
Searching with XLOOKUP
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 takes the price associated with that item number in the price lookup table and enters 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 ...
Get Excel Workbook For Dummies, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
