Help with Formula / INDEX to show previous month's data
Hoping to get a little help with a formula / Index set up. I found a scenario/question similar to what I am needing, but I can't seem to get it to work. The scenario I found provides =INDEX(January@row:December@row, 1, MONTH(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1))
Think it's the INDEX portion of the formula that is causing my trouble (Haven't worked with INDEX or VLookup before).
The columns on my stats sheet are set by our fiscal year Jul 20, Aug 20, etc . The formula needs to pull the previous month's data to be displayed on a dashboard (Metric Widget) and update automatically each month. So when looking at the dashboard this month (Feb), it will show January's data.
Could someone show how this would need to be set up to pull the data correctly?
Any assistance would be greatly appreciated!!
Help Article Resources
Check out the Formula Handbook template!