Downloadable books, macros, and add-ins for Microsoft Excel
Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week

McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams

Lookup data from one worksheet to another
with the Lookup Assistant

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

Add to shopping cart
$24.95

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.

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!

Add to shopping cart

  $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.
 
  Address Assistant
  Colored Cells Sorter
  Compare Lists
                Assistant
  Consolidation Assistant
  CSV File Creator
  
  Data Assistant
  Data Cleaner
  Data Extraction
                Assistant
  Data Loader
  Duplicate Finder
  
  Filter Assistant
  List Searcher
  Lookup Assistant
  Merge Assistant
  Multi-Column Sorter
  
  Name Splitter
  Pivot Table Assistant
  Row Assistant
  Row Extractor
  Row to Column Viewer

  Text File Importer
  Unique Extractor


  Cascade Chart Creator
  Colored Cells Assistant
  CSV File Creator
  Data Loader
  Duplicate Finder

  Lookup Assistant
  Macros Made Easy
  Macro Examples
  Password Assistant
  Spreadsheet Assistant

Recently Viewed
Products :
  • Lookup Assistant
  • Waterfall Chart Creator
  • Chart Labeler
  • Risk Analyzer
  • Data Extraction Assistant


  • Home * About * Contact * Feedback * Upgrades * Money Back Guarantee * FAQ's
    Download Information * Ordering Questions * Support
    Product List * New Products * Products by Others * Excel Solutions

    Copyright 2009 Add-ins.com LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of Add-ins.com LLC.
    Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.