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