Match two criteria and return multiple records - INDEX & AGGREGATE, TEXTJOIN function

Hello Everybody,

This forum has been very useful in the past and I got rusty in Excel formula.

I work for an After school and I am trying to make our roster more efficient.

I have a list of students, the school they attend and a weekly schedule with a "X" for the day they are signed in.
I am trying to organize the pickup and depending on the school they are going they will be picked by a different person.
What I would like to do is, when I wrote the school name, the kids that have a X on the Monday row will be showing.

To complicate the problem, my employer work on a MAC and this will need to be converted to Number app in the long way.
Attached is an example file.
Thank you in advance for your help.

It work perfectly, Thank you so much,
It also help me realized that the formula were not working because my excel is in another languages.
the file you attached translated it.
Thank you again.