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

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