Data Validation Problem [SOLVED]

[sonypsunny]

Given below is a sample of my worksheet. I have 8 service areas and there are about 10 defined inquiries under each service area. So when an inquiry comes I will first select the service area and then the inquiry (I have data validation to avoid typing error). Service area selection is alright with data validation but with inquiry there is a lot to scroll up and down to find the particular inquiry. Is it possible to give data validation in such a way that when I enter in service area, let's say Recruitment, then I should get only the inquiries that is under Recruitment to come in the Inquiry data validation. or is there any other way than data validation?


Date Service Area Inquiry Assigned to Caller Name

02/05/2013 Leave of Absence Vacation Tony Ted

02/06/2013 Recruitment Late Application Ron Ravi


Thanks a lot


Sony

 

[bobhc]

Good day sonypsunny


What you want is dependent drop-down validation with the INDIRECT function this link teaches all


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

 

[sonypsunny]

Thanks a lot. That was really helpful.