Multiple Dependent Data Validation List based on ONE Data Validation List

jschaffranek

New Member
Joined
Sep 24, 2011
Messages
2
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!!
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

jschaffranek

New Member
Joined
Sep 24, 2011
Messages
2
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,129,404
Messages
5,636,088
Members
416,897
Latest member
YAFI

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top