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 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.