Chapter 7

Working with lookup functions

In this chapter, you will

  • Get an overview of Excel’s lookup functions

  • Understand how lookup tables work

  • 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 concept, 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 to a worksheet. Unfortunately, these ...

Get Microsoft Excel 2019 Formulas and Functions, First Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.