Return Data based on current month and previous month from range of data.

I am looking for some help who can give me a excel formula which can return data based on current month and previous month dynamically. Attached the excel for your reference.

You can use this formula in Q3 (just in case the values in column P are not in the same order as column B):

=INDEX($C$3:$N$9,MATCH($P3,$B$3:$B$9,0),MONTH(TODAY()))

and this one in R3:

=INDEX($C$3:$N$9,MATCH($P3,$B$3:$B$9,0),MONTH(TODAY())-1)

Copy both formulae down as required.

Hope this helps.

Pete

Try this,

Q3
=INDEX(3:3,,MONTH(TODAY())-COLUMNS($Q3:Q3)+3)

copied down and across.