How to segregate data lines based on percentage automatically?

[uwish7]

Hello. I am trying to take the percentage based on plant and material number and segregate the handling units to two different plants. For example, in the information below, I want excel to look at another worksheet. if the plant and material match, plant 1 will get 20% of the total 5,801 and plant 2 will get 80% of the total.
Handling unit Total
1234
4567 5801

I was thinking of writing a macro, but I am not that advanced to do that.

 

[onlyadrafter]

Hello

Can you not just use an IF formula i.e. It the two values are the same then multiply total by 20%. Then calculate the difference for the other part. Or am I missing something? You may need a clearer description of the problem.