Chossing from a list

[Daniel]

Please help me,
I need a way to choose a product from a supplier that got
more then one ingredient.
How do I narrow down a list from a specified supplier?

Thank

 

[Debra Dalgleish]

You can use Data>Validation to create dependent dropdown lists. There
are some instructions here:

http://www.contextures.com/xlDataVal02.html