Dependent Dropdowns

Hi,

I am trying to create a file that has three dependent dropdowns. I have got the second dropdown working using the indirect function. My problem is with the third dropdown.

The second and third dropdowns are dependent on the same heading but required in two different columns, see attached file.

Please let me know if I am overlooking something really obvious!

Regards,

Meabh

Thank you! That is perfect