Validation

[efmm00]

I was wondering if someone could help me with validation

I wish to validate a column where I have the possibility of entering 3 different possible attributes with the associated attribute values. ie

Employee No - Attribute ID 10
Cost Centre - Attribute ID 20
Dept - Attribute ID 30

I want the validation to look at the column with the attribute ID to determine which data range should be selected before the data validation begins for that particular row.

 

[venkat1926]

see under
Create a Dependent Dropdown List
in this url

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

this will give you an idea how to go about.