create a single column look up table for the company departments, and a
double column table for employees, showing the department in the first column
and the employees names in the second giving each table a name. To select the
department; using data validation, select from allow 'list' and in the source
type =department_list_name. For your second look up, again select list and in
the source, type =(INDIRECT(VLOOKUP(x,employyee_list_name,2,FALSE)) where x
is the cell reference of the result of the department lookup. This will then
only give the employees applicable to the selected department. The employee
list can be changed whenever the need arises. Hope this helps.

"Annie" wrote:

I have set up a drop down in my first column lsiting 10 company departments.
In the second column I would like a drop down showing the employees for the
specific department selected in the first column.

I have looked at the info on the Contextures site, and I am certain I need
to do a Dynamic list since employees can change, but I I am still confused.
I would appreciate any help.