• Home
• Products
  Product List New Products Downloadable Books Analysis Products Charting Products Data Products Specialty Products Time Saving Products Free Products How to Open and Use
• Download
  Download Information Download Purchased Software Download Upgrades
• Support
  Support Top Support Questions Ordering FAQ's Money Back Guarantee Product FAQ's Online Meeting Excel Problems & Solutions
• Contact Us
  How to contact us Contact Form
• About
  About Add-ins.com LLC Customer Feedback Policies License Agreement

Lookup Assistant A data related add-in product for Microsoft Excel Order online from our secure service Get delivery in minutes! For 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!

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

Customers who viewed the Lookup Assistant also viewed:

• Column Navigator - Quickly and easily find and go to any column on a worksheet via a descriptive list of all the columns!
• Data Loader - Make Excel data loading easier.
• Duplicate Finder - Quickly find and remove duplicates in one list or between two lists.
• Spreadsheet Assistant - Add over 200 time saving features to Excel.  Access the features Microsoft forgot!
• Row Extractor - Extract rows of data into columns for easy review and printing.