Microsoft Office Tutorials and References
In Depth Information
Cell B8 computes the GPA by using the following formula:
The preceding formulas work fine, but you can streamline the GPA calculation quite a bit. In fact, you can use a
single array formula to make this calculation and avoid using the lookup table and the formulas in columns D
and E. This array formula does the job:
Performing a two-way lookup
Figure 8-12 shows a worksheet with a table that displays product sales by month. To retrieve sales for a particu-
lar month and product, the user enters a month in cell B1 and a product name in cell B2.
Figure 8-12: This table demonstrates a two-way lookup.
To simplify things, the worksheet uses the following named ranges: