Vlookup to find multiple variations of a text string

Hi, first time post here so bear with me!   I am trying to create a worksheet that displays a list of shift types with names of staff allocated that shift over the period of a week. I can do this ...