dropdown lists in excel

I have a list of 8 teams witj the players.

Eg team.a vs team b......
So a1 cell has team a n b1 has team b.

I need to display the players of both teams in.cell
C1.


Cell a1 and b1 can is dynamic and can contain any
Of the 8 teams

Really want to help but info is not enough may you please add more enough information?