2 specific secondary drop down lists can be chosen after chosen specific option in primary

Originally Posted by ohlalayeah

Yes, this looks good and is able to solve my problem. Can you make an excel file for me as a sample? ^^ Thanks!

Here it is... hope it's what you need :-).

Let me attach my file here.

I don't know why the second one doesn't work, Cells D20 and F20 on the front worksheet are the secondary drop down lists, but don't know why they are failed. Can you help fiixing it?

I'm having some trouble viewing it (my excel gets funky sometimes, I need a reinstall, but I dont have the disc). Anyway, it looks like your data validation isn't set to "List" in the section that isn't working? Could be my excel chopping it up though.

my primary list is on the worksheet "zList-General" under Column D; secondary lists are on worksheet "z69LSizeChart" columns E-R, the list for vlookup is under columns B-D.

Thanks!

Also, it looks like in your VLOOKUP range your list names are incorrect. These should be exactly what you named the lists they correspond to. Also, the cell being referenced by the data validation (O16) is not in the lefthand column of your VLOOKUP range at all. This could be my excel chopping something up though...

Thanks! Do you mind fixing my excel file and attach here? Sorry, I am too stupid.