I have a list that has two columns. Resources and Assigned project. Some people are assigned to more than one proejct. On another worksheet i want to have 1 pull down for the project names and the 2nd to only show people assigned to that project.

Data Validation.xlsx

Thanks
Will