Mapping Excel data


I’d like to create a mapping sheet to generate a report based on internal data and the data from the client.

The problem is, the products don’t have the same names in our respective databases and I need to include a separate tab with 2 columns, showing how they appear in our systems and in theirs.

How can I use this list of names to generate a report which includes client data and our own product names? Can Excel look for the names in this separate tab, and then generate a consolidated report?

Thanks a lot,


By: Natasha Jevtovic

5 thoughts on “Mapping Excel data

  1. ig

    My relatives always say that I am killing my time here at web, however I know I am getting knowledge everyday by reading thes good articles.

  2. Kimberley

    Greate pieces. Keep writing such kind of info on your page.
    Im really impressed by your site.
    Hello there, You have performed a great job.
    I’ll certainly digg it and individually suggest to my friends.
    I’m sure they’ll be benefited from this site.

  3. Rudy

    You’re so interesting! I don’t suppose I’ve truly read anything like that before.
    So great to find another person with some unique thoughts on this subject matter.
    Seriously.. thanks for starting this up. This site is something that is required on the
    web, someone with a little originality!

  4. vurtil opmer

    Hi there! Do you know if they make any plugins to assist with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains. If you know of any please share. Thanks!

Comments are closed.