There's a sample file here with combined lists:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0014 - Combine Multiple Lists into One'

DaveO wrote:
In setting up data validation to allow a cell entry from a specified
list, you can define a named range to represent the list and enter the
reference =NamedRange. Is it possible to concatenate two distinct
ranges into a single list?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html