I have a dashboard in 'Tower Score Card' sheet and the subsequent Group and Month wise data back up is in the 'Statistics' Worksheet.
In the Dashboard i have created two Drop Down Menus for selecting the Group and Month.
My Requirement is,
When i select the particular Group and Month from the Drop down i want to pull the data for that Group from the statistics worksheet and display that in the Column A of Tower Wise Scorecard Worksheet but
""The main thing here is that i want the previous month data to be displayed here.""
For Example if i select 'Sample Group One' and Select the month 'November' the formula should pull the 'October' month data for the 'Sample Group One'.
Please help me in finding out an OFFSET formula to perform this activity.
Sample Attached. All the references are as per the original file.