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!

As long as your data structures are uniform...
try this

A311: a team number.....eg 7

This formula returns the number of the row immediately above the referenced team's data.
Example: For team 7 that cell is: 268

Please Login or Register  to view this content.

These formulas returns the data from the selected team's grid of data

Please Login or Register  to view this content.

Copy that formula across and down through U347.

Does that help?