Muliplying Daily Numbers by a Monthly Factor

[ashleys.nl]

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?

[arlu1201]

Part of your F1:J6 area was a list and part of it was not, this was creating problems with the formula. Hence, i copied the data over to F9:J13 and worked on the formula.
Use this in D3 and fill down -

 =IF(MONTH(B3)=MONTH($F$10),C3*$J$10,IF(MONTH(B3)=MONTH($F$11),C3*$J$11,IF(MONTH(B3)=MONTH($F$12),C3*$J$12,IF(MONTH(B3)=MONTH($F$13),C3*$J$13,"Not Available"))))

I have used "Not Available" for any data beyond January 2012.