Dear all!
I turn to you in my darkest hour. Just by reading the title you probably know already that this is a complex problem (at least for me) and hard to summarize in one sentence. So let me explain my problem.
The scenario is this:
I have a list of product numbers and product prices (table 1).
I have a list of those (old) product numbers becoming new ones (table 2).
BUT some of those products have been merged together so multiple old product numbers have become one new one.
Now I have a list of the new product numbers and I want to calculate the price of the new product by adding up the price of the old products.
I attached an excel sheet that might help you to understand my problem.
Any help or strategy on how to approach this is HUGELY appreciated!
Bookmarks