Pull field based on other other fields criteria

Hello all,


Need a little assistance here. What I am trying to achieve is have the premium (column C) pulled into the corresponding fields based on the start date which would be the sale date (column A) and then pull it X amount of times which is what column B signifies.

I added a sample file. For example in the first instance (row 3) we have the sale date be 12/2022 for 24 months . So I pulled the premium on that date for 24 months but in row 8 we have it starting in 2/2023 for 21 months so I needed it to start on that date for 21 months which I did manually. Gauging if there is an easier way to get this done? TIA!

May be this work

put this formula in cell d3 and drag
=IFERROR(IF(COLUMNS($D$1:D1)>=MATCH(TEXT($A3,"mmm-yyyy"),TEXT($D$2:$AB$2,"mmm-yyyy"),0),IF(COLUMNS($D$1:D1)<26,$C3,""),""),"")

Thanks, The date aspect seems to work but if i drag it across it does fill in every cell even when the cell should have a 0. For example row 4 should only have 2 months of premium and the rest should be 0, but if I drag it across it feels it all in. Same concept for the first row. If I drag it past 25 month it should be 0 since its for 24 months but it feels in the premium for the 25th month as well

I rechanged it. so use the new formula

Thank you, i think this did it!

You're welcome and thanks for the rep