INDEX - AGGREGATE help

[AYouQueTai]

I'd like a formula to look at the date in P5 of my Matchup sheet and fetch all of the Game ID's from my schedule sheet (can be from 0 to 15 on a given night) and list them from P8 to P22 on the Matchup sheet.
Can anyone help? I asked a similar question yesterday and got a formula that worked great so I tried to modify it for this problem but I cant wrap my head around dividing the aggregate function.

OverUnder2021.xlsx
	P	Q	R
5	Feb-04
6
7	Game ID	Visitor	Home
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Matchup

OverUnder2021.xlsx
	A	B	C	D	E	F
1	GameID	Status	Date	Time	Visitor	Home
2	020001	Completed	Jan-13	5:30 PM	Pittsburgh	Philadelphia
3	020002	Completed	Jan-13	8:00 PM	Chicago	Tampa Bay
4	020003	Completed	Jan-13	7:00 PM	Montreal	Toronto
5	020004	Completed	Jan-13	10:00 PM	Vancouver	Edmonton
6	020005	Completed	Jan-13	10:30 PM	St-Louis	Colorado
7	020006	Completed	Jan-14	7:00 PM	Washington	Buffalo
8	020007	Completed	Jan-14	7:00 PM	Boston	New Jersey
9	020008	Completed	Jan-14	7:00 PM	NY Islanders	NY Rangers
10	020010	Completed	Jan-14	7:30 PM	Carolina	Detroit
11	020011	Completed	Jan-14	8:00 PM	Columbus	Nashville
12	020012	Completed	Jan-14	8:00 PM	Calgary	Winnipeg
Schedule

Cells with Data Validation
Cell	Allow	Criteria
F1:F12	List	=INDIRECT("Teams[Team]")
E2:E12	List	=INDIRECT("Teams[Team]")
B2:B12	List	=Dropdowns!$A$2:$A$4

 

[Fluff]

How about

+Fluff 1.xlsm
	P	Q	R
5	13/01/2021
6
7	Game ID	Visitor	Home
8	20001	Pittsburgh	Philadelphia
9	20002	Chicago	Tampa Bay
10	20003	Montreal	Toronto
11	20004	Vancouver	Edmonton
12	20005	St-Louis	Colorado
13
14
15
16
17
18
19
Data

Cell Formulas
Range	Formula
P8:P19	P8	=IFERROR(INDEX(Schedule!$A$2:$A$100,AGGREGATE(15,6,(ROW(Schedule!$A$2:$A$100)-ROW(Schedule!$A$2)+1)/(Schedule!$C$2:$C$100=$P$5)/(Schedule!$A$2:$A$100<>""),ROWS(P$8:P8))),"")
Q8:R19	Q8	=IFERROR(INDEX(Schedule!E$2:E$100,AGGREGATE(15,6,(ROW(Schedule!$A$2:$A$100)-ROW(Schedule!$A$2)+1)/(Schedule!$C$2:$C$100=$P$5)/(Schedule!$A$2:$A$100<>""),ROWS(Q$8:Q8))),"")

In future it would help if you supplied data that matched you criteria.

 

[AYouQueTai]

Awesome, works great. Thank you!

 

[Fluff]

Glad to help & thanks for the feedback.