Combining two non-contiguous lists into one for data validation, with one range being dynamic

[elmerg]

Hi all,

So I'm trying to figure out how to combine two named ranges in Excel, into one range for data validation purposes. One of the ranges in question always has the same name. The other range in question will change names based on another data validation. Example:

First data validation drop down is in a cell named Clan, and contains A, B, C and D.

Another data validation drop down needs to be created, combining the contents of BaseList and a named range list based on the Clan drop down.

So if Clan = A, the second validation list needs to contain AList + BaseList.
if Clan = B. the second validation list needs to contain BList + BaseList.

Any help would be appreciated!