I want to create conditional drop down list when user fill the year in column A and in column B is filled the range which is taken from list defined in column E. How can I do it?

CodePudding user response：

Here is a solution which requires a few helper columns

Chose from Drop Down menue