Dynamic Moving Average Formula

  • Thread starter Thread starter STEVEN TAYLOR
  • Start date Start date
S

STEVEN TAYLOR

Hi All,

I would really appreciate any help in trying to solve the following problem:

I have a forecast model and I am trying to create a dynamic moving average.
Specifically, I need a formula to look at a cell, which contains the
current month i.e. June. It then needs to look up the month in a column,
which contains all the months of the year. Once it finds the match, it needs
to take the value in the next column over as well as the value of the prior
two months before it and calculate the average of these three months.

The calculation needs to update whenever the month value is changed.

Any suggestions would be greatly appreciated.

Thanks,

Steve
 
Back
Top