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...