Index match help

[Sondrelarsen]

Hey.
Im trying to build a betting model, and i need some help.
right now i have started a new sheet where i want all the stats for players.
i have a drop down list for leagues and teams, but i cant figure out how to get automated updated names when i change team from example Germany to Spain.
i have every name for the players on every team, but as i said, i cant get the names coming up when i change from one team to another.

 

[gargamalebarbosa]

Do you have any link for get that information ?

 

[Sondrelarsen]

what do you mean?

 

[gargamalebarbosa]

what do you mean?

I need data for try formulas