Hello,

I want to build multiple cascading dropdown lists in excel.. which means the dropdown of Column 2 is depended on the selection of Column 1 dropdown; while dropdown of Column 3 is depended on the value of Column 2.

I am able to create the first level of cascading which the Column 2 dropdown is cascading from Column 1, but as the data validation of Column 2 is =indirect(Column 1), i am not sure how could i build the cascading dropdown for Column 3..
Please help!