This content has been marked as final. Show 3 replies
I am struggling looking up and multiplying across data sources. I want to multiply the units from the first image by the cost of the product in the second image multiplied by the customer multiplier on the third image. For example: 1 Apple unit * 5 (cost of an apple) *0.5 (for customer A).
At the end I want a summary for the cost for customer A and B.