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" wrote in message
...
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