Drop Down Lists Dependent on Two Factors

[olimajor123]

Hi there,

I am making some drop down lists but the options that one returns is dependent on what has been entered into two other drop downs. I know you can link then up by using the INDIRECT function if there is only one other list that affects it but how would I do it if there are two.

For example the drops downs could be.

First Dropdown - Data group called "Name" - You can pick A, B, C or D
Second Dropdown - Data group called 'Number' - You can pick 1,2,3 or 4


If the first one reads A and the second 4, I want the third dropdown to only give the option of "Red". If the first reads A and 2, then I want it to give the option of "Yellow" etc.

I understand I could probably use an IF function instead of the third dropdown but ideally I want to stick to the dropdowns if possible.

Any help would be appreciated.

Thanks

 

[Eric W]

How are you creating the drop down lists? Form Combobox, ActiveX combobox, Data Validation, VBA form? Also, if for every combination of values from the existing 2 dropdowns results in only one choice, do you really need another dropdown, or should you just populate the cell, and remove one step for the user?