I am using a validation list as my primary selection (Part Family)
then a 2nd validation (base off family) for my sub list (Part Type).
Base on the data selected from “Family” and “Type” there are 2 to 12
attributes required.

Most of the attributes are free form, but, some are standard. I would
like to format the “Standard” cell to have validation list added. I
am working with 36 Primary selections, 1 to 10 secondary selections,
and 2 to 12 attributes. I started with IF’s it getting to be un-
manageable.

Can some recommend a different approach? Also, was told that and
array is the way to go, but, I have never used array before… Can some
one help???

Thanks you in advance for any and all help with this matter…