9. Working with Lookup Functions

Locating 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 4Creating Advanced Formulas,” that you can add option buttons and list boxes to a worksheet. Unfortunately, these controls return only the number of the item the user has chosen. To find out the actual value of the item, you need to use the ...

Get Formulas and Functions: Microsoft® Excel 2010 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.