create a multiple drop down list that will populate data.

I am trying to create a multiple drop down list that will populate from a data set attached to this is the workbook example.
Please help!

Thanks,

J

I am trying to get data from a set of data by using multiple dependent drop down lists. If you open the file I submitted there is more instruction on there.

Here is another example

Drop down list
Fruit-->Apple, Banana, Orange
Vegetable--> Carrot, Potato

Data Set:
A B C
1 Food GroupFoodType qty
2 Fruit Apple 1
3 Vegetable Carrot 3
4 Fruit Orange 1
5 Fruit Apple 3
6 Vegetable Potato 1


Now I need it to populate data from this list from a multiple dependent drop down list. The end result would look like this:

Fruit-->Apple -->qty

A B C
1 Food Group Food Type qty
2 Fruit Apple 1
3 Fruit Apple 3
4

Thank you for taking the time to help.

-J