Attempting to make a match list

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

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

Your sheet doesn't make much sense. I cannot which cells you want matched with which other cells. What's all the stuff in columns H to Q? Where are the phone numbers and the emaila ddresses that you want to get copied over?

MailPhone =Sheet1!$G$2:$H$6
partners =Sheet1!$B$2:$D$6

Please Login or Register  to view this content.

Please Login or Register  to view this content.

It can be deleted. I left it there for a quick comparison.

Try:

Please Login or Register  to view this content.

If you want line breaks as:
name:
email
phone,
then use:

Please Login or Register  to view this content.