Dynamic Dashboard based on the month/date

I have a monthly sheet of various stats that get collected on a monthly basis. Therefore I have my columns as Jan/Feb/March etc. and my rows as my various measures.

what i need help with is, based on the current month (march), show me the previous month's values. so that when i look at the dashboard now, i see february stats, and in april, it will automatically show me March's stats.

I get that there needs to be an additional column with some month() formula, which i can't figure out, but then how will you select the column you need.

I'm thinking a =vlookup(A1:F10,month(),false). something like that where month() would return the month value, and then vlookup that many columns?

Best Answer


  • ArthurC
    ArthurC ✭✭✭✭

    that was very insightful. thank you very much for the detailed breakdown of the formula

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! 👍️

    Please don't forget to mark the most appropriate response as "helpful" so that others searching for a similar solution can know that one may be found here.