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