Drop-down lists dependent on selection from another drop-down list

[amask]

I have created a dependent drop-down list (four (4) of representing departments, Executive, Finance, Operations, and Developments) for a Purchase Order template, with each Department only seeing certain budget codes.

However, for Developments requisitions a further field is required called 'Cost Codes' which is a shortened code for the type of development expenditure being incurred, eg 'ARCHITEC' is for Architect requisitioned expenditure.

What I am trying to do is if the department Developments is selected from the drop-down list, the data-validation list of Cost Codes are shown in a separate cell but if any of other three (3) Departments are selected they are not.

Please see my attachment which should make my query clearer.

Is this possible??


Thanks,

 

[Toadstool]

Hi Amask,

I can't see rows/columns but it looks like your word "Development" is in about D6.
Insert a table of your Cost Codes and name it Development.
For your new LoV (E11?) set it as Data Validation, List with Source of =INDIRECT($D$6)

If D6 contains anything except "Development" it fails on the name so no options appear. If Development is in D6 it offers the entries for your table called Development.