Multiple Drop Downs dependent on the previous

    Okay I have created my first drop down list no problem
    Created the second with no problem.
    I need the third to be dependent on the first two.
    Problem is that the second drop down has repeats from the first drop down.


    I am dealing with material list type in first drop down.
    Second is material size which we all know that some types but not all materials coming in the same sizes as others.
    Problem is third drop down will be pricing based on the first two drop downs.


    How can I make the third drop down list the prices of the material based on the first two drop downs.
    I have 9 material types and have 6-22 different sizes depending on material with some sizes repeated.

    Re: Multiple Drop Downs dependent on the previous


    In the data validation for the third drop down list you can put a formula in there. =if(and(Cell1="option1",Cell2="option2"),First_List_of_options,if(and(Cell1="option3",Cell2="option4"),Second_List_of_options,Third_List_of_options))


    You can also replace the and() with or().

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login