Muliplying Daily Numbers by a Monthly Factor

Hey Everyone,

Again, thanks for your help these past few months!

Currently, I have created an excel work book that totals all the daily quntities reported in a month. Once I have analyzed these quantities, I create something called a "monthly factor". I want to then go back to the daily reports and multiply the daily reported quantities by the associated monthly factor.

I would like to use a formula to do this. The formula would recognize in the daily report section within what month the quantity was reported and then multiply the quantity by the associated monthly factor.

I have attached a work book for clarification. The highlighted columns are the ones I wish to multiply.

Any thoughts?