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

Hi,

Attached is a file using the OFFSET and MATCH functions instead of a VLOOKUP. This will enable you to have a large list of Sub1 and Sub2 using the item (Item A, Item B etc...) in the match and a countif to determine the return for the drop downs.

HTH
Steve

Dependent Drop Downs2.xlsx

I like that. I never would have thought of using OFFSET & MATCH. I use VLOOKUP all the time, so it's usually my go to formula for stuff like this. Anyway, here's a link to a video that uses Ohlalayeah's scenarios with the VLOOKUP.
http://www.youtube.com/watch?v=0kYzmBncec4

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!