Hi Guys,

I need some help listing only name who are in Team A, Team B, Team C ETC.

I tried vlookup but it only brings back the first name of the match but not the unique name of everyone in the table/array

I have attached a sample below. If someone could help that will be greatly appreciated, Thanks

Sample.xlsx