Thank you, thank you, thank you!!!! I implemented your code and it is almost perfect!!! There is one problem. In some cases, the same person is responsible for more than one department. In my list, it will give me the first selection for that person correctly, but if their name comes up again in the list, it will give me the next name in the list. How do I correct that?