Hi there, I've got this problem i'm trying to solve, I have an excel file, with names of people and their choices of partner (matches) for a game.
I'm trying to create an automatic way to sort matches between the name and their choices with corresponding matches. please see excel file, in column A we have names with color, and in B-D we have matches with color.
Lets start with line 2A - Sue, her name is seen 2 times on the list as a match with Drew and Bob. Now we cross reference and see that Bob is on Sue's match list(2B) but Drew is not.
So Sue and Bob match.
What I need to do is cross reference matches with names to see if two names both choose each other.
So for this example
When matches are made I'd like a column that puts in match information. So in the line for Sue, I'd want Bob's Match Information at G2(name, email, phone).
Please check out the file below.
thanks Sprout
Bookmarks