Multiple Dependent Data Validation List based on ONE Data Validation List

[jschaffranek]

I hope someone can help me with this or point me to a post about this. I wasn't able to find anything.

I've figured out how to use DV Lists and Dependant Lists, but I'm unable to create multiple Dependant Lists (with varying data) to point to the value chosen in one DV List.

I can't use nested IFs because I have too many variables.

For instance:
I have 4 products:
Address Label, Invitation, Announcement, and Photo Book

Aside from those, I have varying specifications for each product under certain categories:

Size, Stock, Finishing, Die Cut, etc.

I need my spreadsheet to update the value in the different categories with data that is only for the selected product.

Say... if I select Address Label, the categories for Size, Stock, Finishing, and Die Cut will all update with options specific to Address Labels (as drop down lists).


I hope that was clear enough. I want to try and avoid using VBA, but I'll accept any type of help or suggestions! :D

Thank you!!

 

[VoG]

Is this any help? http://www.contextures.com/xlDataVal02.html

 

[jschaffranek]

Thank you for your response! That link is actually how I figured out how to create dependent lists originally. It also shows how to create multiple dependent lists based on the previous list, but not multiple lists based on one list only.

I understood that as:

If A, then B
If B, then C
If C, then D


What I'm trying to do is something like:

If A, then B
If A, then C
If A, then D


Maybe that's not possible in excel?