Linking multiple rows of data to one option on excel data validation list?

I need to know if what I'm wanting to do is even possible. I am trying to make a rotating schedule for associates in multiple departments at my store. I want to have a data validation list that when I...