multiple dependent lists

**CUNLA** · 09-30-2012, 03:32 PM

I have a database of autos by make, model and year in columns. I need to create a drop down list by first choosing the make (no duplicates), then a dependent second list that would give me ONLY the models of that maker. Then finally a third dependent list of year for only that model. see attached spreadsheet.
Cells A2, B2 and C2 are where I need to make the drop down lists that are dependent on the previous list.
Thanks for any help that can be offered.

**ratcat** · 09-30-2012, 08:19 PM

G'day

Please read through this page http://www.contextures.com/xlDataVal02.html

The information on that page starts off with the basics then leads into the answer your looking for.

Happy to answer any other questions you have.

**CUNLA** · 09-30-2012, 09:04 PM

I have already seen that contextures site, and using that method, I was able to do the first column only. I was unable to validate columns b and c.
Thank you for the suggestion though.

**pareshj** · 05-20-2014, 09:58 PM

It is very simple to create dependent drop down list in excel. Check out the below link and follow the steps,

http://snpinfotech.wordpress.com/201...ists-in-excel/

**kvsrinivasamurthy** · 05-21-2014, 07:10 AM

Pl see attached file.

**pareshj** · 05-21-2014, 10:01 AM

Hi kvsrinivasamurthy,

What else you want to do in the attached file. Only Issue in the file was duplicates entries, which is not possible to remove once data validation is applied to range of data. If you want dependent drop down list to work with no duplicate values, you have to use VBA code to achieve the same.