• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Dropdown


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.



  • Conditional Dropdown.xlsx
    13.5 KB · Views: 9