Hello everyone

i have a spreadsheet detailing employees, with a maintenance page to add / remove etc Employees.

on this maintenance page, i have a validation list for 'Department' (such as Executive, HR, Account Management)

I have been asked to include a new field for Team, as each department has several teams. IT for example has Applications Support, Systems Development and Service Delivery.

The volume of teams is different for each department, but i would like this new field to populate with the correct Teams relative to the Department selected.

the only way i can think of doing this is Via a series of Vlookups and IF statements that will provide a list of teams, and have the validation list look at these results. this would mean in some cases however, 'Blanks' or N/A's would be avaialble for selection.

does anyone have any suggestions on how to do this in a more tidy fashion?