somebody help!!
i need to creat series of drop-down menu with series of data.
cell A : cell will have 12 choices (from column X : 12 items)
cell B : per each choice in cell A, a dropdown menu with 10 choices each
(from colum Y : 10 items per 12 choices from cell A=120 items)
column C : per each choice in cell B, an additional dropdown menu with 10
choice each (from column Z : 10 items per 10 choice from cell B=100 items)

because "list" option from "data validation" function won't allow "if"
function, i can't come up with the right function.

please help.