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

Oct 7, 2013
Reaction score
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!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question