Hi everyone,

I know this is probably really simple and I am just overlooking something.

What I am trying to do is predict furture spendings and planning for maintenance for a proposed budget. What I have is multiple maintenance plans that use a qty of materials. These plans are set at different monthly periods and I need to be able to propose a budget for the next say 200 months.

What I am hoping is possible, is that I can create a formula that will look at the frequency in colum A, look at the month offset in row B2 and onwards and put the QTY in the corresponding months with the allowance to offset as I have manually put in for the 2 month plans.

Is this possible?

Frequency and future planning.xlsx