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
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