Match month lookup

[kahnailee]

I need to have a dynamic, ever-growing list that pulls prior month data, but keep the previous months intact. The range in A17:D18 comes from an OLAP cube, which updates every month and shows prior month data. I'd like to have that data be recorded monthly via a lookup, but not lost when a new month passes, if that makes sense.

What I have now can't be the best solution as it creates a circular reference at times. Anyone have a better idea?

[peterjuhnke]

Hello
Have a squiz at this and see if this is what you are after; P.S. You'll need to change the last argument on each column

Change =IF($A11=$A$18,$B$18,B11)
To =IF($A11=$A$18,$B$18,0)

Peter

[kahnailee]

Hello
Have a squiz at this and see if this is what you are after; P.S. You'll need to change the last argument on each column

Change =IF($A11=$A$18,$B$18,B11)
To =IF($A11=$A$18,$B$18,0)

Peter

Thanks for the reply. That'll change the values to $0 if/when the month passes. Change the "Oct 2015" in the lower range to "Nov 2015" and the data in the November row (12) is okay, but now October (11) is zero. That's my dilemma.