Add multiple named ranges in data validation for selection

[jeffreybrown]

I know in one of my past threads I have an answer that would probably solve this for me, but after performing a search I just can't find that thread.

I use the below in a custom list in data validation which works fine for two named ranges, but I need to add more references than two.

Please Login or Register  to view this content.

I tried something like

Please Login or Register  to view this content.

but data validation does not accept this.

Can I get a shove in the right direction?

[TMS]

Can't test just now but could you use MATCH and CHOOSE ... or CHOOSE and MATCH depending on how you think about it.

Regards, TMS

[MarvinP]

Hey Jeff,

Are you talking about Cascading Validation?
http://www.bluepecan.co.uk/excel_tra...alidation.html or
http://excel-user.blogspot.com/2011/...ion-lists.html

[jeffreybrown]

Thanks Marvin and TMS...

Got it worked out. There was a gremlin in the spreadsheet and now that I have evicted him I'm going to use the Indirect method of cascading validation.

[jeffreybrown]

Hi Marvin and TMS,

I finally found the thread I was referring too, so after finding the thread and a good nights sleep...TMS, you were right on for what I was seeking.

=CHOOSE(MATCH(G2,I1:K1,0),DV_CIV,DV_CME,DV_MIL)

Thanks again to both of you for your help and interest

[TMS]

You're welcome. Thanks for the rep. TMS