Now I have your attention
what I'm actually looking for runs on a very similar premise, but for mentors and mentees? I have a two lists of people and attributes including location, department and institution they are member of, and I'd like to be able to assign the most suitable people to each other. So for example a doctor who works in London will be paired with a junior doctor also in London from the same institution.
I've been looking at various concatenations and then vlookups to get matches, but this gives the exact match. What I'd like is for it to still work when say only 2 out of three criteria are met as well, but for the best matched pairs to be matched first?
Thank you for your help!
I've been looking at various concatenations and then vlookups to get matches, but this gives the exact match. What I'd like is for it to still work when say only 2 out of three criteria are met as well, but for the best matched pairs to be matched first?
Thank you for your help!