Hi all,

I am trying to get different results to display on the screen depending on what option is chosen from a drop down list.

For example - if there's a drop-down in Cell A1 that allows users to choose from three different categories:
Liquids
Veggies
Fruits

If a user selects "Liquids" - i would like the next column to display a list of pre-defined liquids, i.e. coffee, tea, juice, etc

If a user select "Veggies" - i would like the next column to display a list of pre-defined veggies, i.e. carrots, squash, potato, etc.

I'm familiar with how to create the drop-down list in A1 using Data Validation. I have all of my categories defined as ranges to match the options given on the drop down. So for example, if someone chooses "liquids" - i have a corresponding "liquids" range that defines all of the items that are liquids.

What I'm not sure about is...how to tie it all together.

Thanking you in advance...