Good morning,

I've attached an example spreadsheet of what I'm trying to do. The Info tab contains all the information regarding different people. In the second tab, I am trying to list names and level based on shift selection. Thanks for the help!

Regards,
M

Test.xlsx