Forum

I was able to make this work with a combination of Powery Query (Get & Transform Data) and using INDIRECT with Data Validation. I'm sure...

See attached actual file. On the first tab, Input, when a team is entered (Column A), I need the Pos column (Column E) to only show their available r...

Your "output" is exactly what I was trying to do. I could not figure out the "grouping" as you mentioned. I want to take a longer look at your file ...