Index/match to continue displaying results after first true result

[Mandy_]

Hi,
I am creating a day planner, and wanting to enter 'reminders' into one sheet and pull that information if the date matches the date on the top of the day's planner.
For example: I'm working on 1st May 2021. Screenshot of my reminders table and screenshot of my planner.
I can get the result only of the first true value, how do I change my formula please to also include multiple results (when I have reminders with the same date twice).

I currently have the data in the same sheet, but if can it be done when the data is in separate sheets (this would be preferred)!

If I drag down the formula on my reminders section, it just copies the 'Test 1' result.

Thank you for your help,

 

[Eric W]

Try:

B13:

=IFERROR(INDEX(Sheet18!JU:JU,AGGREGATE(15,6,ROW(Sheet18!$JT$5:$JT$100)/(Sheet18!$JT$5:$JT$100=B$4),ROWS(B$13:B13))),"")

and drag down.

 

[Mandy_]

Thank you very much!!