Google Sheets - Dropdown / Dependent Drop Down

[mattbarb]

Hi, Im trying to create a sheet were a dropdown referenaces a range and in turn when a item is selected it change the adjacent dropdown items change . Something like the below.
Im loosing my mind trying to sort it. Many thanks,

 

[veyselemre]

Hi, watch this

 

[mattbarb]

Hi, watch this

Thanks. I did try that but couldn't get it to work

 

[veyselemre]

 

[mattbarb]

Hi, many thanks for the above but I just cant get it to work. I must be a dummy.

 

[veyselemre]

Prepare a sample sheet that is open to share. Add the link here, let's apply it on.


Also, I have a list separator ';' as a regional setting. you may have ','. ';' in formulas Replace it with ','.