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