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


Joined
Oct 7, 2013
Messages
1
Reaction score
0
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!
 
Ad

Advertisements


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

Top