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