Microsoft® Excel® 2010 Formulas & Functions Inside Out

Using Search and Reference Functions

The table structure of Excel worksheets allows the user to systematically search worksheets for information.

Searching Through a Cross Table

Assume that you have tabulated price information for an item (in this example, shirts in different colors and sizes). After selecting a color and size, you want to look up the price and use this price in further calculations (see Figure 2-21). To do this, you use a typical cross tabulation.

Figure 2-21. Prices based on size and color.

Excel offers a range of lookup functions that ...