Dropdown based on a selection

[mattbarb]

Hi, hope someone can help me here.
Im trying to crate a sheet that creates a dropdown of roles based on the selection of a department.


Example below of what I’m trying to achieve.

https://we.tl/t-oFAukUJE6p


Thanks!!

 

[BlueAure]

Are you looking for a VBA or formula solution?

 

[mattbarb]

Are you looking for a VBA or formula solution?

Sorry, looking for a formula but just cant get one to work.

 

[BlueAure]

You should follow this Office Support Article to add a listbox that is linked to a range.

https://support.office.com/en-us/ar...in-excel-579e1958-f7f6-41ae-ba0c-c83cc6e40878

Then, all you have to do is change that range to match what you want in your dropdown.

 

[mattbarb]

Sorry just cant get this to work, can anyone help please?