XL: Using the Lookup Wizard for Microsoft Excel (Lookup.xla)Last reviewed: February 2, 1998Article ID: Q147255 |
The information in this article applies to:
SUMMARYThe Lookup Wizard is part of a series of add-on wizards that Microsoft has made available to enhance your use of Microsoft Excel. The Lookup Wizard helps you to write formulas that find the value at the intersection of a column and a row in a rectangular range of cells on a worksheet. The add-in in this article is provided "as is" and Microsoft does not guarantee that it can be used in all situations. Although Microsoft Technical Support engineers can help with the installation and existing functionality of this add-in, they will not modify the add-in to provide new functionality. NOTE: The Lookup Wizard is included with Microsoft Excel 97 or Microsoft Excel 98 Macintosh Edition.
MORE INFORMATIONThe Lookup Wizard creates lookup formulas that find the value at the intersection of a column and a row. The formulas that the wizard creates use a combination of the lookup functions that are available in Microsoft Excel. Below is a detailed description of each step in the wizard, followed by an example.
Step 1 of the WizardIn this step, you need to specify the range of cells containing data that will be used for the formula. This range must include column labels and row labels. For the most part, this means you need to select the entire list on the worksheet. Like most of the Microsoft Excel add-ins, the dialog box will open with the Range Edit box filled in. Microsoft Excel (version 5.0 and later) is designed to determine where your list is. If the range is not filled in correctly, you must select the correct range, either by using the mouse or by typing it in manually. NOTE: It is important to have column and row labels in the data range specified. The wizard uses these labels in the following steps.
Step 2 of the WizardThe result of the formula that this wizard creates is the intersection of a row and a column. In this step, you need to specify the row and column labels that correspond to the intersection that the wizard will find. There will be a list for each the column and the row labels. Select a label from each list. In both lists, the first option ("No column label matches exactly" and "No row label matches exactly") is used to create a new value. Microsoft Excel uses the largest column or row label less than or equal to the new value. If a new value is created for the column argument, then an existing label must be chosen for the row argument. Likewise, if a new value is created for the row argument, an existing label must be chosen for the column argument. If you attempt to create a new value for both the column and row arguments, the following message appears:
You must choose at least one existing value to match. Your existing value can be a row label or a column label. Please try again. Step 3 of the WizardIn this step, the wizard copies the formula to the worksheet. There are two different ways that the wizard can copy the formula to the worksheet. Use either of the following options:
Step 4 of the WizardDepending on which option you chose in step 3 of the wizard, the information that is needed in this step changes. Depending on which option you chose, do either of the following:
Example of the Lookup WizardNOTE: Before you can use this example, you must install the add-in. Please download the file and see the Readme.txt file for the installation instructions. In Microsoft Excel 97 and Microsoft Excel 98 Macintosh Edition, click Add-Ins on the Tools menu and select Lookup Wizard. The add-in discussed in this article can be obtained from the Microsoft TechNet compact disc and from Online Services. For additional information on downloading a file from Online Services, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q119591 TITLE: How to Obtain Microsoft Support Files From Online ServicesTo use the Lookup Wizard, do the following:
|
Additional query words: 5.00 5.00a 5.0c 5.00c 7.00 97 98 XL97 XL98 XL7 XL5
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |