The Lookup Wizard can help you easily display a value that appears at the intersection of a row and a column in a range, even when your worksheet contains dozens of rows and columns. For example, suppose that you are a teacher and you have a worksheet that contains test score information as well as grades for class projects. The worksheet contains information for several tests and several projects for all of the students in the class. In your worksheet, you list the students in column A, and the various scores in subsequent columns. Using the Lookup Wizard, you can easily pull out any variation of test or project scores for any given student. You identify the range containing the scores, the column containing the score you want to see, and the row containing the student’s name, and Excel does the rest. Or, suppose that you maintain a worksheet that contains parts that your company manufactures and the scheduled manufacturing dates for each part.
Using the Lookup Wizard, you can quickly and easily identify the scheduled manufacturing date for any part.
The Lookup Wizard - Step 2 of 4 dialog box appears.
5 Click here to select the column containing the value you want to find.
6 Click here to select the row containing the value you want to find.
7 Click Next. The Lookup Wizard - Step 3 of 4 dialog box appears.
8 Click an option to copy the formula into the workbook ( changes to ).
Note: This example copies the formula and the lookup parameters.
9 Click Next. The Lookup Wizard – Step 4 of 6 dialog box appears.
• You can use this dialog box to select a cell to hold one of the labels that describe the value.
10 Click here. Excel collapses the dialog box so that you can click in the worksheet.
11 Click the cell where you want the label to appear.
• Excel enters the address of the cell you selected.
12 Click .
1 Comment(s)
happy new year...