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

Hi,
Look into Debra Web page she has an excellent example

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

Hope this help
"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

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

the sample seems to indicate the only way to do this is to have the data in
seperate columns. the table i have is for all 50 states - is there any way
to do this with a filter and not change the data table?

"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

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