Pull player names specific to teams from a data base

[srallen3]

I have a tab in excel that has every nba player name in one column, their team name in the next column, and then stats in the columns following. I am wanting to start a new excel tab that has each team's individual roster. Is there a formula that can search the first tab database for "Bro" (Brooklyn Nets), and then return the 1st player's name that plays for Brooklyn? I would then drag this formula down several cells to return all of the Brooklyn Nets players names without duplicating any of them.


Thank you in advance!