Multi-dependent dropdown lists

itaroled 

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.