Matching shifts to staff availability using partial data.

[Luder94]

Hi,

I receive shifts from one source in a table and I have the availability of staff in another source in a table.

I would like to return the name of the staff that is available in the column 'Name' in the Shifts Received table.

I have tried using INDEX and MATCH but I'm struggling as I need to use multiple criteria as well as using partial matches.

Also if two people are able to do the shift, which name would return first?

My question is, how do I match the name of the staff that is able to meet the needs of the shift?
I want the name to return in the Name column in the Shifts Received table.

Shifts Received

Date	Time	Location	Grade	Code	Name
25/08/2020	19:00:00	Rainborough	Grade 4	CEL	?
26/08/2020	10:00:00	Longward	Grade 2	CEL	?

Availability of staff

Name	Date Available/	Time Available	Location	Grade	Code
Anne Smith	25/08/2020	19:00; 19:30; 19:45	Rainborough; Stockward; Fenbridge;	Grade 4	CEL
Paul Worthing	26/08/2020	09:00; 09:30; 10:00	Stockward; Longward	Grade 2	CEL
Beth Rowe	25/08/2020	19:00; 19:30; 19;45	Stockward; Rainborough	Grade 4	CEL