Hi,

I needa formula where if i select a certain department all the people
in that department will appear in a drop down list in the template. i
am wondering if we could use IF function to do this....

to give more perspective i am trying to build a travel template which
can be used by all departments in the company to plan their trips but
instead of creating multiple tabs for each department i am wondering
if i could simply create one template and when anyone selects their
department it would automatically put a list of the people (similar to
the way a pivot works but cannot have a pivot as this needs to be a
column in the template.

this would be for the department heads so would make sense if they
could simply chose their department and all the list of their
employees would appear as a drop down.

Any idea?

Thanks!

Rosana