Data Validation based on first, second or third data validation li
 

Another validation question. I have three columns (all three are data
validation drop-downs):

COL A contains MaterielCodes
COL B contains MaterielClass

I want COL C to be a drop-down list of names associated with the Code AND/OR
the Class.

Actually, I'm working with a list of over 4,000 hazardous chemicals where
"CAS Code" is the preferable entry to find the name (there is generally only
one name associated with each CAS Code); however, if the user doesn't know
the CAS Code, I want to enable them to find the chemical name based on other
drop-down menu choices (Hazard Class; Hazard Route)

The best solution will be if users select a Hazard Class first, then select
from Hazard Route, a much reduced list of Hazard Names will appear and, after
selection, the associated CAS Code would then be automatically placed in the
appropriate cell.

I realize my best solution is more complex -- however, if someone has
already done it, I would greatly appreciate the help!

Thanks -- Suzanne

Thanks again -- Suzanne

Data Validation based on first, second or third data validation li
 

Suzanne,

It sounds like this is what you are trying to do:

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

HTH,

Conan




"Suzanne" wrote in message
...
Another validation question. I have three columns (all three are data
validation drop-downs):

COL A contains MaterielCodes
COL B contains MaterielClass

I want COL C to be a drop-down list of names associated with the Code
AND/OR
the Class.

Actually, I'm working with a list of over 4,000 hazardous chemicals where
"CAS Code" is the preferable entry to find the name (there is generally
only
one name associated with each CAS Code); however, if the user doesn't know
the CAS Code, I want to enable them to find the chemical name based on
other
drop-down menu choices (Hazard Class; Hazard Route)

The best solution will be if users select a Hazard Class first, then
select
from Hazard Route, a much reduced list of Hazard Names will appear and,
after
selection, the associated CAS Code would then be automatically placed in
the
appropriate cell.

I realize my best solution is more complex -- however, if someone has
already done it, I would greatly appreciate the help!

Thanks -- Suzanne

Thanks again -- Suzanne

Data Validation based on first, second or third data validatio
 

I've been studying the Contextures material. The examples appear to provide
(great) solutions for 'one-way' validation -- I'm looking to get a drop-down
list based on Col A *or* Col B.

"Conan Kelly" wrote:

Suzanne,

It sounds like this is what you are trying to do:

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

HTH,

Conan




"Suzanne" wrote in message
...
Another validation question. I have three columns (all three are data
validation drop-downs):

COL A contains MaterielCodes
COL B contains MaterielClass

I want COL C to be a drop-down list of names associated with the Code
AND/OR
the Class.

Actually, I'm working with a list of over 4,000 hazardous chemicals where
"CAS Code" is the preferable entry to find the name (there is generally
only
one name associated with each CAS Code); however, if the user doesn't know
the CAS Code, I want to enable them to find the chemical name based on
other
drop-down menu choices (Hazard Class; Hazard Route)

The best solution will be if users select a Hazard Class first, then
select
from Hazard Route, a much reduced list of Hazard Names will appear and,
after
selection, the associated CAS Code would then be automatically placed in
the
appropriate cell.

I realize my best solution is more complex -- however, if someone has
already done it, I would greatly appreciate the help!

Thanks -- Suzanne

Thanks again -- Suzanne