I want to create a drop down list with only the item & function. Then
depending on what item/function is picked, i need the dept and class and
subclass to appear in 3 seperate cells.

this is the example of my list ....

(item) (function) (dept) (class) (subclass)
Sofa - Stationary, 1086, 1, 1
Sofa - Sleeper, 1086, 1, 2
Loveseat - Stationary, 1086, 2, 1
Loveseat - Sleeper, 1086, 2, 2


--
I will Excel at Excel!