Forum Discussion
Multi-dependent dropdown lists
I am looking for a way to make the options given in a dropdown list dependent on the outcomes/selections made in multiple other dropdown lists.
For example, dropdown lists in D3 (intent) and E3 (reps) determine the dropdown list options in F3.
If D3 selected "MEDIUMHEAVY" and E3 selected "4", F3 should produce a dropdown list that gives the options "79.00%" and "76.50%", respectively. However if D3 again selected "MEDIUMHEAVY", but E3 selected "2" instead , F3 should produce a dropdown list that gives the options of "83.00%" and "81.00%", respectively.
30 Replies
- NikolinoDE
I used a combination of your attachment and mathetes attachment to help solve the problem of creating the multidependent dropdowns so thank you both once again! I have one more issue arising however.
I will need this series of dropdowns to occur roughly 15-20 times in a given sheet, and each series will need to be independent of eachother. Is there a way to copy and paste these throughout a sheet without needing to rewrite their filters, validations, and formulas manually?
Thanks!Is it safe to assume this reply of yours to NikolinoDE supersedes the private message you sent me? That, in other words, you've answered the question you were asking me?
It would be helpful to me (and I suspect to NikolinoDE as well) if you could attach a copy of your existing solution with an example or two of those additional sets of multi-dependent drop-downs. That way we could work with what you have. You probably will have to do it again as a private message to each of us.
In the absence of that, not seeing how you've done it, my gut tells me that you might want to set up a table with the names of the various drop-downs and their relationships, and then use VLOOKUP to retrieve the name or reference to the appropriate list, embedding that in an INDIRECT. BUT I hasten to add, this is just a gut sense of what might work.
I'm giving an example of that VLOOKUP nested in an INDIRECT in cell I8 of the attached spreadsheet. This gets results, in this case from one of two tables of discounts. It can easily be extended.This doesn't have the multi-variable drop down, but using this method in conjunction with whatever you've already done may serve to get the result you want. Oh, this is also important: you need to make use of named ranges. If you're not familiar with named ranges, here's a good reference.
- I will give it a shot and let you know NikolinoDE
thank you!
I'm attaching an example I created for somebody else. Perhaps you can use this to build your own, just by modifying the table to the left on the spreadsheet. You can change the entries there now to whatever combinations you have in mind.....
Please come back with questions if you have any.
- Thank you very much! This looks like it will solve my problem but I will definitely return here if anything else is needed!
