The table structure of Excel worksheets allows the user to systematically search worksheets for information.
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 ...