Hello Dear friends,

Please help me to auto populate monthly and quarterly data data from a table of monthly figures. Please see attached.

Basically just by by updating the current month in B2 cell, data should auto matically populate from the table shown
Say if I type July in B2 cell, it should automatically populate the values from the table on the right for the month of July

Similarly for the Quarter.


Appreciate your attention