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