Hello Excellers,
I'm currently stuck with a problem that I'm hoping someone can help shed so light on. I receive two different reports one with the proper cost and another that has less cost than the proper cost what I did was take the difference from the proper cost and the other cost to get the difference, but now I need to add that difference back in according to Type and Topping and that is the trouble I'm running into. The goal with this is to get the difference multiplied by the cost based on the matching columns, for example, if column 1 = Pizza and column 2 = Pepperoni then multiply the cost by the value in the table above. I tried using isnumber and search but I was having trouble matching multiple columns. Enclosed is a sample problem of this whereas the actual is thousands of rows in which I'm hoping there is a formula that would help streamline this.
Thanks for any help with this!
Bookmarks