To do this we will need to set up a few items in our workbook.

A cell for our genre selectionA range for our list of genresRanges for each list of films within each genre

We are going to let the user select from these three genres: Drama, Comedy and Horror.

Now when you select a genre, the drop down list for the title selection will change depending on the genre. Fancy!

How To Create A Conditional Drop Down List - 98