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

Suzanne,

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

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

HTH,

Conan




"Suzanne" <(E-Mail Removed)> wrote in message
news:2A613D8B-F02A-4410-ADF5-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:2A613D8B-F02A-4410-ADF5-(E-Mail Removed)...
> > 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
>
>
>