Hello All,
Please find my attached excel 2003. I want to make 3 level independent drop down lists.
On Sheet1 worksheet I have 3 drop down lists: 1st, 2nd and 3rd.
- 1st drop down list is simple, just to lookup the list B2:B4 on worksheet "List1" (the name is given "Items").
- 2nd drop down list depends on the chosen option of 1st drop down list. E.g. If I choose "Ballpen" in 1st drop down list, I will have options of Black, Red and Blue in 2nd drop down as shown on the worksheet "List2".
- 3rd drop down list depends on the chosen option of 2nd drop down list. E.g. if I choose "Black" in 2nd drop down list, I will have options of Variant1, Variant2 and Variant3 as show on the worksheet "List2".
But how can I do this? Thanks!!
Bookmarks