I did some more reading and found the answer under
http://www.contextures.com/xlDataVal13.html

Thanks for pointing me in the right direction.
Jack

"Sheeloo" wrote:

In a separate sheet set up 'Names' matching the options in the first col...
and options in the second col as the range

See http://www.contextures.com/xlDataVal02.html for an excellent description
on how to do this.
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Jack" wrote:

I need to do a validation on a subset of a list. My data is as follows

In A1 is the Value "AL"
in B1 i would like to validate based on the below data in A5:B9, but i only
want the values for state AL - Autauga and Baldwin to show in the Validation.

State County
AK YAKUTAT BOROUGH
AK YUKON-KOYUKUK
AL AUTAUGA
AL BALDWIN