Conditional Data being used for data validation input.

Question

I may be approaching this the wrong way, but I am looking for a pointer as how to use a single excel data table to populate a series of data validation drop down lists in a separate sheet

For example, I have a dynamic table that is representing a player, team and a detail reference eg:

Player	Team	Ref
Sam Jones	Red	1
Will Smith	Red	3
Adam Brown	Orange	1
John Smith	Blue	3
Dan Mills	Orange	2

elsewhere on a separate sheet I would like a drop down list input to select the team, ie it would just then show the option of Red, Orange and Blue. After that I would like a second drop down that would allow to select the player in the team.

eg if Red was selected, The next drop down would present both Sam Jones and Will Smith, or Blue just John Smith. Lastly, based on that input in a third cell it would display the "players" details for that combination of input to get a unique value on the separate sheet.

Thanks

mathetes · Answer

mybrrh&nbsp;&nbsp;Attached is an example workbook I created for similar purposes. You should be able to copy the concepts from this. Come back with questions if you have them.

mybrrh · Answer

mathetes&nbsp;Thank you kind sir. &nbsp;&nbsp;...Of course it is just my luck I am using a Mac so I am running Office 2019 for Mac, so the SORT, UNIQUE and FILTER functions don't exist for me... &nbsp;&nbsp;All the same, it helped and has given me some pointers... &nbsp;

mathetes · Answer

mybrrh&nbsp;&nbsp;FWIW, I'm on a Mac as well. But I do have the Microsoft 365 Subscription service going. I'd recommend it. These new functions alone are worth it.&nbsp;

mybrrh · Answer

mathetes&nbsp;&nbsp;I actually found another cheat workaround by using a couple of Pivot tables to organise the data for me. &nbsp;It was not perfect but close enough.&nbsp;Thanks for your help...

Forum Discussion

Conditional Data being used for data validation input.

4 Replies

Resources