R

#### rbrown999

Product Total

50000 to 100000 the training component will be 7500

100001 to 250000 the training component will be 17500

and so on.

I have the product ranges in cells A31 through B35 and the training costs in the corresponding C31:C35

The product totals are in cells D2224

So I'm looking for help building a formula that sums D2224 then takes that number, identifies where it is in the range of A31:B35, then vlookups across to enter the amount that's going to be in C31:C35

TIA