Index Match within Date range multiple results

[Kyle12488]

Hi,

I would like to the name(s) to appear on another sheet if the exact date falls within the "Start date" and "End date" and status is "approved".
i have come out something like this "
=IFERROR(INDEX(Holidays5[Name],MATCH(1,INDEX((Holidays5[Status]="Approved")*(Holidays5[[Start Date ]]<=CalendarView!$M$19)*(Holidays5[End Date]>=CalendarView!$M$19),,),0),'Master File'!A$4:A4),"")" but it doesnt return multiple results"
Please make it that it will return multiple results.

Thanks

[thomglea]

While I have not begun to dissect your formula yet, I first want to make sure you are pressing CTRL+SHIFT+ENTER when entering it as it is an array formula.

[Kyle12488]

While I have not begun to dissect your formula yet, I first want to make sure you are pressing CTRL+SHIFT+ENTER when entering it as it is an array formula.

Yes the formula is working fine. But I want all the dates that match to appear instead of just the first result.