Page 164 - Excel Workbook for Dummies

16_798452 ch11.qxp 3/13/06 7:40 PM Page 147
Chapter 11: Using the Lookup Functions 147
Figure 11-3 shows you a situation where you need to look up two values, the Part
Number and the Date, in order to return the Quota from the 2006 Production
Schedule table. You will use the Lookup Wizard add-in in the following exercise
to return the production quota from this table based on these two lookups.

Figure 11-3:
Performing
a two-way
lookup
in the
Production
Schedule
table.

Try It

Exercise 11-3: Using the Lookup Wizard to Build Formulas that Perform Two-
Way Lookups in a Table
Open the Exercise11-3.xls workbook file in your Chapter 11 folder inside the My
Practice Spreadsheets folder or in the Excel Workbook folder on the workbook
CD-ROM. This workbook contains the Production-06 worksheet with the 2006
Production Schedule you need to practice performing a two-way lookup using the
Lookup Wizard add-in:

1. Select the Lookup Wizard check box in the Add-Ins dialog box (Tools➪Add-Ins)
and then select OK.
Select the Yes button in the alert dialog box if you are prompted to install this
add-in.
2. Choose Tools➪Lookup on the Excel menu bar.
Excel opens the Step 1 of 4 Lookup Wizard dialog box that prompts you to indi-
cate the cell range to search including its row and column labels. In this case,
you must select the range B3:K7.
3. Select the cell range B3:K7 in the Production-06 worksheet (‘Production-06’!$B$
3:$K$7 appears in the text box) and then select the Next button.