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