Index/Match/Offset Multiple Values

Hi guys

I am struggling with a formula to look individual days and tell me which drivers are on "rest day". So for example all drivers on rest day list for Sunday. I have tried index and match formula but it only returns the first value. Can some please adivse? Any help appreciated from a novice

Any

Please see the attached.

I've used data validation to get a drop down in the yellow cell and an event driven macro to dynamically create the list. You will find the code by hitting Alt F11 and going to the sheet1 tab.