I've got a bit of an oddball one that's doing my head in. I feel its more complicated than I'm anticipating

I need two drop-down lists the second of which is dependent on the selection in the first.
  • For argument's sake, Column A has a dropdown with 9 options
  • If any of the green cells are selected, the second dropdown would give the green options in Column B 'Yes' or 'No'
  • If any of the yellow cells are selected, there is no option and only 'Maybe' would show.

Dropdowns.PNG