Hi folks. I have created a dynamic dropdown list that allows me to choose i.e. movie or music titles based on if movies or music was selected in a dropdown in the previous column. Is it possible to reference that same music/movies column for another list that could possibly allow me to choose from a list of genres for movies/music?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Referencing a cell twice for data validation list
- Thread starter tatooedsn
- Start date
jasonb75
Well-known Member
- Joined
- Dec 30, 2008
- Messages
- 15,507
- Office Version
- 365
- Platform
- Windows
That would need what is known as a dependent list. This link contains the best guide to setting them up that I have seen so far.
Easy Steps Excel Dependent Drop Down List Data Validation
Easy steps for Excel dependent drop down list. Conditional data validation based on other cell, Region/City. Videos, written steps, get free Excel file
www.contextures.com
Upvote
0
I just realized this is a bad example because I could just create a list that referenced Music/Movies for Genres and then have Titles refer to Genres column. But in my case I'd like to have both genres and titles reference the column where you select music or movies.
Upvote
0
Similar threads
