|
 View Cart
Home
About Add-ins.com
Support
Money back guarantee
Customer feedback
New Products
Upgrades
Download Purchased software
Excel Problems
& Solutions
Site search
INDIVIDUAL PRODUCTS:
Macro Books
Time Saving Products
Charting Products
Data Products
Analysis Products
Specialty Products
Free Products
PRODUCT COLLECTIONS:
Visual Basic Collection
Productivity Suite
|
|
|
 |
|
Lookup Assistant
A data related product for Microsoft Excel
Order online from our secure service
Get delivery in
minutes!
Works in Excel 97, 2000, 2002, XP, 2003, and 2007
Order Risk Free - Money back guarantee if not
satisfied
 $24.95
Buy individually or as part of
the
Productivity Suite and save!
|
|
Do you have these problems:
- Do you waste time trying to find matching data in one list?
- Want the ability to customize your look up searches?
- Need the guidance of menu driven searches to expedite your tasks?
The Lookup Assistant can solve all of these problems and more! |
The Lookup Assistant 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.
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 cells containing the identifiers of the values to be copied if there is a match. Multiple columns can be specified.
-
The data columns containing the data to be returned if there is a match on the IDs. Multiple columns can be specified
-
The starting destination column for the matched data.
There are several options to assist you in determining what was loaded or not loaded. You can click on the checkbox that colors the loaded data green. You can also click on the checkbox that colors IDs that were not matched. And you can have an X placed in any column on the sheets with the IDs being looked up for those that did not get matched to anything. This allows you to filter on the rows containing X's.
You are given the option of either loading matching values or inserting a simple formulas (ex: =F23) or a VLOOKUP formula to the matching data.:
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.
Regarding the Lookup Assistant, Mark Reid told us:
"After 18 hours of wading through 6,000 lines of a 40,000 product database I had almost given up entirely. I then spent over an hour trying various programs that offered a quick fix for my problem but none of them met the exact criteria until I found Lookup Assistant - within 15 minutes of installing the add-in I had completed the database restructure! I can't thank you enough for this excellent addition to Excel!" |
|
Order online from our secure service.
Get delivery in
minutes!
|
|
$24.95
|
|  |
