I have 3 tables in separate worksheets name:
2018
2019
2020
All have the same exactly headers
On another page i'm creating scrolling quick view page the client wants to show his colleges, and not sift through a data table.
HERE is where it gets me. I've used INDIRECT well but not for an INDEX / AGGREGATE
=INDEX(Table2018[Date],AGGREGATE(15,6,(ROW(Table2018[Month_Rpt])-ROW('2018'!$W$2)+1)/(Table2018[Month_Rpt]=$F$6),ROWS(F$9:F9)))
Here was my attempt: B6 = Year Selection
So the goal is to be able to change the year in B6 and the Formula redirects to the right table.
=INDIRECT("INDEX(Table" & $B$6 & "[Date],AGGREGATE(15,6,(ROW(Table" & $B$6 & "[Month_Rpt])-ROW('" & $B$6 & "'!$W$2)+1)/(Table" & $B$6 & "[Month_Rpt]=$F$6),ROWS(" & F$9:F9 & ")))")
Bookmarks