I have validation set in column c that runs from a list in column w.
Depending on the value chosen red,blue, or green, I would like the validation
in column c to run from a list in column x, y or z respectively.

Sorry typo
I would like the validation
in column d to run from a list in column x, y or z respectively.

"Qaspec" wrote:

I have validation set in column c that runs from a list in column w.
Depending on the value chosen red,blue, or green, I would like the validation
in column c to run from a list in column x, y or z respectively.

Hello,

Name your ranges (that you want your validation to pick from) in x, y and z;
'red', 'green' & 'blue' & then use INDIRECT in the validation source for
column D.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"Qaspec" wrote:

Sorry typo
I would like the validation
in column d to run from a list in column x, y or z respectively.

"Qaspec" wrote:

I have validation set in column c that runs from a list in column w.
Depending on the value chosen red,blue, or green, I would like the validation
in column c to run from a list in column x, y or z respectively.

Qaspec,

Chris Marlow is correct in his suggestion. But, incase it is difficult to understand without examples, check this out--a step by
step tutorial on dependent validation lists. I found it very valuable and easy to understand:

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

I hope this helps,

Conan


"Qaspec" wrote in message ...
Sorry typo
I would like the validation
in column d to run from a list in column x, y or z respectively.

"Qaspec" wrote:

I have validation set in column c that runs from a list in column w.
Depending on the value chosen red,blue, or green, I would like the validation
in column c to run from a list in column x, y or z respectively.