Data Validation based on data to left but several columns dependen
 

I have a document that has has validation/name ranges, e.g., in column A I
have a dropdown choice of Apples/Oranges; in column B, if I have chosen
Oranges in column A, I want the choices in column B to be Valencia/Blood,
etc.; if I chose Apples in column A, then I want the column B choices to be
Gala/Delicious, etc. It works currently with an =indirect(A1) as the formula
in B1; however, I now want to expand to columns C, D, etc., so that if I have
chosen Gala in B1, then I have choices in column C, and on and on. HELP!

Thanks!

Marv Lusk
Boise Corporation

Data Validation based on data to left but several columns dependen
 

Debra Dalgleish's site:

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

go down to the "D's" and under Data validation, find dependent dropdown.

--
Regards,
Tom Ogilvy


"MarvInBoise" wrote:

I have a document that has has validation/name ranges, e.g., in column A I
have a dropdown choice of Apples/Oranges; in column B, if I have chosen
Oranges in column A, I want the choices in column B to be Valencia/Blood,
etc.; if I chose Apples in column A, then I want the column B choices to be
Gala/Delicious, etc. It works currently with an =indirect(A1) as the formula
in B1; however, I now want to expand to columns C, D, etc., so that if I have
chosen Gala in B1, then I have choices in column C, and on and on. HELP!

Thanks!

Marv Lusk
Boise Corporation

Data Validation based on data to left but several columns depe
 

Ah, is that Office2007? I don't see such a choice in my list under
Data/Validation? Only:
any value
whole number
decimal
list
date
time
text length
custom

--
Marv Lusk



"Tom Ogilvy" wrote:

Debra Dalgleish's site:

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

go down to the "D's" and under Data validation, find dependent dropdown.

--
Regards,
Tom Ogilvy


"MarvInBoise" wrote:

I have a document that has has validation/name ranges, e.g., in column A I
have a dropdown choice of Apples/Oranges; in column B, if I have chosen
Oranges in column A, I want the choices in column B to be Valencia/Blood,
etc.; if I chose Apples in column A, then I want the column B choices to be
Gala/Delicious, etc. It works currently with an =indirect(A1) as the formula
in B1; however, I now want to expand to columns C, D, etc., so that if I have
chosen Gala in B1, then I have choices in column C, and on and on. HELP!

Thanks!

Marv Lusk
Boise Corporation

Data Validation based on data to left but several columns depe
 

Oh DUH, I got it! :(

Thanks!
--
Marv Lusk
Boise Corporation


"MarvInBoise" wrote:

Ah, is that Office2007? I don't see such a choice in my list under
Data/Validation? Only:
any value
whole number
decimal
list
date
time
text length
custom

--
Marv Lusk



"Tom Ogilvy" wrote:

Debra Dalgleish's site:

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

go down to the "D's" and under Data validation, find dependent dropdown.

--
Regards,
Tom Ogilvy


"MarvInBoise" wrote:

I have a document that has has validation/name ranges, e.g., in column A I
have a dropdown choice of Apples/Oranges; in column B, if I have chosen
Oranges in column A, I want the choices in column B to be Valencia/Blood,
etc.; if I chose Apples in column A, then I want the column B choices to be
Gala/Delicious, etc. It works currently with an =indirect(A1) as the formula
in B1; however, I now want to expand to columns C, D, etc., so that if I have
chosen Gala in B1, then I have choices in column C, and on and on. HELP!

Thanks!

Marv Lusk
Boise Corporation