Using Search and Reference Functions

image with no caption

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.

Prices based on size and color.

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

Excel offers a range of lookup functions that ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

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