This one has been a real melon-scratcher for me, hoping someone can help me figure this out.
Context :
There are 20 football teams, and 4 types of players - GKP, DEF, MID & FWD
All the data is present in one single table under the 3 headers
Requirement :
If I select the Position and Team name, I'd like to find the potential results as a dropdown in the third cell.
As illustrated in the example below, I'd like to see D9 and D12 show up as a drop-down for me to choose in I7
Note -
The data source comes in the format above and includes about 450+ names across the 20 teams.
I thought of concatenating the Position and Team name to use as a unique identifier but I'm struggling to get the matches show up as a drop-down (data-validation)
Appreciate any assistance that you can offer!
Context :
There are 20 football teams, and 4 types of players - GKP, DEF, MID & FWD
All the data is present in one single table under the 3 headers
Requirement :
If I select the Position and Team name, I'd like to find the potential results as a dropdown in the third cell.
As illustrated in the example below, I'd like to see D9 and D12 show up as a drop-down for me to choose in I7
Note -
The data source comes in the format above and includes about 450+ names across the 20 teams.
I thought of concatenating the Position and Team name to use as a unique identifier but I'm struggling to get the matches show up as a drop-down (data-validation)
Appreciate any assistance that you can offer!