Xlookup - Duplicate values in array, multiple unique returns

Hello! 

I'll try to make this as simple as possible. 

I have a list of employees. Each employee has a name, job title, and team. Each employee name is unique, but they can share job titles and teams. There are 4 teams. Each team needs 1 supervisor, and 5 operators. 

We already have a bunch of people hired, but I want to create a dashboard to track our hiring progress to see which roles are filled (and by who), and which roles are vacant. 

So, I run a report from our HR system. I get a list that looks like this:

Here's what I'd like my dashboard to look like (I want employee names in the empty cells):

For each "Name X" I'd like to pull from the report. Supervisors are easy enough using a simple Xlookup. But I can't use an Xlookup for the operators because there are multiple unique names that share the same job title and team. At first I was messing with Xlookups with multiple criteria like this:

This function works for one name. I go down to the second operator on team A and it'll give me the same name. I changed the function to return the last found variable which gave me a different name, but this solution only works if there are two operators, not 5. 

I'm now convinced that Xlookup is not my solution. Here's my question: How do I lookup values using multiple criteria, but have the function skip duplicate returns? I feel like there is a solution to this that I'm not quite getting. 

Again, my end goal is to be able to run a report from my HR system, copy/paste the formatted data in my spreadsheet, and my dashboard will be updated. 

Thank you in advance!