• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Validation Problem [SOLVED]

sonypsunny

New Member
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
 
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
 
Back
Top