Data Validation (2 lists)

Hello, I have 2 different "Lists" with a "Name" defined to each, and I would
like to use them both on a Data Validation but it seems it is not as simple
as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able
to use both?

,thanks

I don't believe you can do what you require so you will need to combine into
one list. And I'm not sure why you would want to use two lists.

"Ed" wrote:

> Hello, I have 2 different "Lists" with a "Name" defined to each, and I would
> like to use them both on a Data Validation but it seems it is not as simple
> as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able
> to use both?
>
> ,thanks

Assuming there is some other cell whose value decides which List you wish to
use, then you could do a Change-event macro on that cell to set up the
DataValidation on the other cell to use the appropriate list.

hth
Vaya con Dios,
Chuck, CABGx3



"Ed" wrote:

> Hello, I have 2 different "Lists" with a "Name" defined to each, and I would
> like to use them both on a Data Validation but it seems it is not as simple
> as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able
> to use both?
>
> ,thanks

I don't think you can do that, but would need to create a third list with
the matched items.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ed" <Ed@discussions.microsoft.com> wrote in message
news:8795DDA1-5BD4-458F-A30A-23FB94C32E6D@microsoft.com...
> Hello, I have 2 different "Lists" with a "Name" defined to each, and I
would
> like to use them both on a Data Validation but it seems it is not as
simple
> as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be
able
> to use both?
>
> ,thanks

http://cjoint.com/?gDvlrMsErZ

=3DIF(Row()<=3DCountA(champ1),INDEX(champ1,LIGNE()),INDEX(champ2;Row()-Coun=
ta(champ1)))

Cordialy JB


Ed a =E9crit :

> Hello, I have 2 different "Lists" with a "Name" defined to each, and I wo=
uld
> like to use them both on a Data Validation but it seems it is not as simp=
le
> as =3DAND(NAME1,NAME2). It gives me a error in that way, any ideas to be =
able
> to use both?
>=20
> ,thanks

You could use a custom formula, but you won't see a dropdown.

=OR(ISNUMBER(MATCH(A1,list1,0)),ISNUMBER(MATCH(A1,list2,0)))



Ed wrote:
>
> Hello, I have 2 different "Lists" with a "Name" defined to each, and I would
> like to use them both on a Data Validation but it seems it is not as simple
> as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able
> to use both?
>
> ,thanks

--

Dave Peterson

Another option is to use formulas to create a single list from multiple
lists, as shown in the sample file here:

http://www.contextures.com/excelfiles.html#DV0014

Under Data Validation, look for 'Combine Multiple Lists into One'

Ed wrote:
> Hello, I have 2 different "Lists" with a "Name" defined to each, and I would
> like to use them both on a Data Validation but it seems it is not as simple
> as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able
> to use both?
>
> ,thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html