Hi

Hoping someone can help me

Im looking to produce a formula

I need a drop down box in J19 with options

Monthly commission £2
Monthly commission £2.33
Monthly commission £2.55

Then the below formula will calculate the number of carbon tonnes and multiply it by the monthly commission amount chosen in the drop down box and put it in the correct pay period. See below

To fill in cell J21 i want the formula to look up Column G the words Period 9. Any rows which contain Period 9 need the Cell D (Carbon Tonnes) on the same row to be multiplied by the number in the drop down box in J19 which will give me my answer

If someone could let me know how I can do it that would be great. I think it would need something to

Tester.xlsx