I have a worksheet that we keep monthly data for reporting our key performance indicators. I have created a lookup to capture that latest months data for the current month. I'm looking for a way for the previous months data to populate the column "Previous Month" something like max column - 1 column.

Attached Files

Water Supply Treatment Operaional Key Performance Indicatores Measures FY16 (5).xlsx (29.8 KB, 10 views)

So for today, the latest month would be July and the previous month would be June, right? Sure, that can be done.

And your data table to the right...is there a specific reason why it starts in May and ends in April? Will there be a new sheet added for next year or will you be adding on to it?

Anyhoo, there are probably better ways to do it, but the beauty of Excel is always that there are usually a dozen or two ways to skin a cat, some more elegant than others. But here's a start. I only did it for the Chlorine data (in yellow), but the formulas can be copied if you choose to go this route.

Attached Files

Water Supply Treatment Operaional Key Performance Indicatores Measures FY16 (5).xlsx (30.2 KB, 9 views)