Filter List Data based on Selection

[RichDenman]

Hi There,

I am perfectly happy using the Data Validation function to create a drop down list however what I would like to do is have two drop downs and have the content of the second list dependent upon the first.

eg

I have three manufacturers of Ice Cream and each manufacturer has three different flavours. Not all manufacturers have the same flavours though.

Could I set up a spreadsheet so that I select the Manufacturer name in the first box and then the second drop down only displays the flavours which that manufacturer makes? I guess I have to do some sort of filtering of the validation sort data but I am not sure how I could do that. I dont know any VB.

Thank you

Rich

[maninweb]

Hi Rich...

A way without using VBA is included in the attached sample file. The sample includes two data validation dropdows, the first for selecting a
country and the second for selecting a city of that country. Each country is defined as a named range as well as the country list. The first
data validation list refers to the countries and the second uses the formula =INDIRECT($B$16) where B16 is the first validation list.

Hope this helps.

Regards :-)

[jsuarezg]

Hello,
You can do it also using the IF function to select the list that you want according the first text that you select.