Hi - I have a list of start dates and end dates for our fiscal calendar for 2 years and another column that shows if those months are for the past 365 days. To show a rolling 12 months. I need to be able to use an index match to then show those 12 months (start and end date) based on if that column has "TM" in the column. When I use index match it displays the first start date instead of showing me a list of 12.
=INDEX('Date 2'!$C$8:$C$31,MATCH(Data!A11,'Date 2'!$E$8:$E$31,0))
=INDEX('Date 2'!$C$8:$C$31,MATCH(Data!A11,'Date 2'!$E$8:$E$31,0))