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

Leave a Reply

Your email address will not be published. Required fields are marked *