Repeating cell values at a starting point determined by another cell

[Patrick101]

I am trying to populate a recurring value shown in (E4:E12) in column I that will need to be repeated for a number of months that is referenced in another cell (D4:D12). These values must begin at a month that is referenced in B4:B12. Also, currently I have filler columns J through P that I would like eliminate. Can I consolidate the formulas into column I so I can add more information to the table A4:E12?

I have added a tab labeled "Explanation" to the workbook to hopefully clarify this further.

Thank you in advance for your help with this Brain Busting Excel Dilemma!

Patrick

 

[bosco_yip]

In J4, copied across and down :

=IF((VLOOKUP(J$3,$A$4:$E$12,2,0)<=$G4)*(COUNT(J$3:J3)<=VLOOKUP(J$3,$A$4:$E$12,4,0)),VLOOKUP(J$3,$A$4:$E$12,5,0),"")



Regards
Bosco

 

[Patrick101]

Bosco,

Thank you so much for your help! I can't tell you how many hours of frustration you saved me today.

You are the best!

Patrick

 

[Peter Bartholomew]

Using dynamic arrays
= MMULT(
IF( (modelPeriod>=TRANSPOSE(Month)) * (modelPeriod<=TRANSPOSE(Month+DepreciationMonths)),
TRANSPOSE(DepreciationAmount),
0 ),
SIGN(Month) )
entered into cell I4. Otherwise the same formula as a CSE array entered into the range I4:I139.