Selecting a specific range

I have 7 different teams - Team 1, team 2 etc. - which all share the same subset of data.

I want the user to define which team to select and filter for that team's data at the bottom (row 310 onwards). So for the the team selected, the relevant percentages are pulled down.

I have tried using INDEX-MATCH but to no avail. Would anyone know of an elegant way of doing this?

Your help is much appreciated.

Tommy

PS forgot to add. Once the team is filtered for, I then want to filter for a subset (e.g. A, B, C etc.) so left with one row which is the result of filter by team and subset!