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 an...