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

E

elmerg

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!
 

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

Similar Threads

Data Validation with dynamic ranges 2
Data validation list using filtered range 3
Filesize: embedded data validation lists all stored independently? 2
Join non-contiguous ranges into one range via named range? 3
Data Validation - dependant Lists 1
How to optimize? large non-contig cell range for data validation l 5
Changing named Validation list to Dynamic list. 1
data validation 1

Top