Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)

CHAPTER 7

Working with lookup functions

In this chapter, you will

• Get an overview of Excel’s lookup functions

• Understand how lookup tables work

• Taking lookup to the next level with XLOOKUP

• Look up a value using the CHOOSE function

• Look up a value using a table

• Perform advanced lookup operations

Getting the meaning of a word in the dictionary is always a two-step process: First, you look up the word itself, and then you read its definition. Same with an encyclopedia: First look up the topic, and then read the article.

This idea of looking something up to retrieve some related information is at the heart of many spreadsheet operations. For example, you saw in Chapter 2, “Creating advanced formulas,” that you can add option buttons and list boxes ...