Lookup Assistant

Lookup data from one worksheet to another with the Lookup Assistant

The Lookup Assistant for Microsoft® Excel® is designed to find matching data in one list and load in another. For example, if you have a price list of product numbers and prices in one worksheet and in an invoice worksheet you just have product numbers, the Lookup Assistant will match the numbers in the invoice to those in price list.  You are given the option of either loading matching values, inserting a simple formulas (ex: =F23), or  a VLOOKUP formula to the matching data.

The Lookup Assistant prompts you for the following information:

• The cells containing the identifiers to be looked up.  Multiple columns may be specified.  The Lookup Assistant will concatenate the columns.
• The data columns containing the data to be returned if there is a match on the IDs.  Multiple columns can be specified
• The identifiers for the data so that they can be searched for matches.  Multiple columns can be specified.
• The starting destination column for the matched data.

The following is the main dialog of the Lookup Assistant:

There are several options to assist you in determining what was loaded or not loaded. You can click on a checkbox that colors the loaded data green. You can click on a checkbox that colors IDs that were not matched.  And you can have a text comment placed on the rows of the lookup values to indicate if a match was found or not.   The following is the main options dialog for the Lookup Assistant:

The Lookup Assistant is fully menu driven and comes with a help file and an exercise file.  The exercise file gives you step by step instructions to help you quickly learn how to use the Lookup Assistant.