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