Filter List Data based on Selection

RichDenman

New member
Joined
Dec 14, 2011
Messages
7
Reaction score
0
Points
0
Excel Version(s)
2016
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

New member
Joined
Mar 22, 2011
Messages
88
Reaction score
0
Points
0
Location
Germany
Website
excel-translator.de
Excel Version(s)
2010, 2016, 2016 Insider
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 :)
 

Attachments

  • Rich.xlsx
    10 KB · Views: 27

jsuarezg

New member
Joined
Sep 21, 2013
Messages
24
Reaction score
0
Points
0
Hello,
You can do it also using the IF function to select the list that you want according the first text that you select.
 
Top