Validation Drop Down List if cell meets criteria

[clueless]

Hi,
Need some help. In my spreadsheet, Column B has a dropdown list of depts.
Need to know if there is a way of making Column C show only a dropdown list
of employees in that department. For example, if the dept chosen in Column B
is management, Mary, Joe & Paul would only show on the dropdown menu in
column C. But if the dept was human resources in Column B, Kathy, Mark &
Mike would show on the dropdown menu in column C (not Mary, Joe & Paul). Is
this possible? Thanks in advance for your help!

 

[Eduardo]

Hi,
yes it's possible with dependent lists see Debra examples

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

if this helps please click yes thanks

 

[Jacob Skaria]

Check out the below articles by Debra..

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

If this post helps click Yes

 

[clueless]

Hi,
Thanks for all your help. I decided to go with the Val 13. It took a while
but finally got it. I do have one more question. Can there be another
validation off of employee (meaning dept breaks down to employee, employee
breaks down to the task at hand and then the task breaks down to a specific
task - example accounting, Mary, receivables, posting cash)? Not sure if I
picked the correct html. Any suggestions. Thanks again, very much
appreciated.