Thank you. Yes there are the same number of persons and departments in the lists and I made sure the spelling of the departments was the same between the two lists. I'm not sure if this makes any difference but there are 32 items in each list. Could that be too many for an If statement to sort through?
|