I want to populate a list box with filtered values from column y based on the
value in column x matching the value in cell a1.

Column y contains a list of players.
Column x contains the team to which the player belongs
A1 will be updated by the user with the team name
The list box will then display the players who are members of the team in A1

I'd be grateful for suggestions how to acheive the filtering rather than
populating the list box with all column y values and therefore displaying
all players irrespective of their team.

Thanks in advance,

David