How to do a vlookup with multiple results and provide them with no duplicates

timbo83

New member
Joined
Sep 20, 2013
Messages
2
Reaction score
0
Points
0
Hey guys, so hoping some of you will understand the model I'm trying to set up so you can help! Basically I have a list of names that correspond to a job they can do. There could be multiple people/names that can all do job 'x' and names that can all do job 'y' etc. In the fields id like to populate, I have repeat job roles 'x' and 'y' etc. What formula would work best to assign people to roles without repeating an individual's name. I can't have the same person in two spots.

I've attached what I have so far... all i can get is a vlookup that will match a person to a role, however it will put the same person in the next time that role comes up and not skip to the next person on the list who can do the job.

Your help would be greatly appreciated!

Tim
 

Attachments

  • MPempschd.xlsx
    13 KB · Views: 26
Good morning,

I'm not sure if this is what you're looking for, but it may help. With this logic, the same people would be scheduled for the same job in the same spot every day. It's probably possible to incorporate some randomness, but I'd have to research that (or someone more intelligent could help :)).

Good luck,
 

Attachments

  • MPempschd_sample.xlsx
    15.7 KB · Views: 43
Works!

bgoree09, dont sell yourself short that was well done, exactly what I wanted thank you! I spent hours on it literally lol. Thanks again.
 
Great to hear! Glad to help. You're very welcome.
 
Back
Top