Conditional Dropdown

[msharma864512]

Hi,

I need to create conditional dropdown list with values from more than four columns. I need to create dependent drop down list in cell L2 to Cell L6. Hence, If I select AMM as sector, it should pull only values from AMM from column B to F, accordingly if I select "Automotive" as sub-sector from Column B, the other dropdown should only show the adjacent values for Automotive. Similarly, create the drop down for others such as Function, Normalized Function etc.

Regards,
Manish

 

[pecoflyer]

Here you go https://www.contextures.com/xldataval02.html

 

[msharma864512]

Here you go https://www.contextures.com/xldataval02.html

Thanks.. I have gone through this. while it will work for two columns... but my table has four columns dependent on each other

 

[pecoflyer]

You should read the article entirely. There is a link to an answer to your query https://www.contextures.com/exceldatavaldependadvanced.html

 

[djc]

Hi,

I need to create conditional dropdown list with values from more than four columns. I need to create dependent drop down list in cell L2 to Cell L6. Hence, If I select AMM as sector, it should pull only values from AMM from column B to F, accordingly if I select "Automotive" as sub-sector from Column B, the other dropdown should only show the adjacent values for Automotive. Similarly, create the drop down for others such as Function, Normalized Function etc.

Regards,
Manish

Please see the attached file, which uses the same LAMBDA based method I shared on your other thread:

https://chandoo.org/forum/threads/dependent-dropdown-list.57437/post-308454

 

[msharma864512]

Please see the attached file, which uses the same LAMBDA based method I shared on your other thread:

https://chandoo.org/forum/threads/dependent-dropdown-list.57437/post-308454

Thank You Very much.. this worked perfectly

 

[djc]

Thank You Very much.. this worked perfectly

Glad to hear it. You're very welcome.

In case you're interested, here's another example where the same method has been applied to every row in a data entry table...