Copying cells from one sheet to another based on duplicate conditions

[broseidon]

Good Afternoon,

I'm trying to find a formula that would help me copy info from one cell to another cell in a different sheet based on some duplicate information between those sheets.

Here is an example of what I'm trying to do:

Sheet 1
Column A | Column B
1. Baseball | Mike
2. Tennis | John
3. Bowling | Tim
4. Baseball | Ben
5. Running | Scott

Sheet 2
Column A | Column B | Column C
1. Football | Mike | Red
2. Baseball | Ben | Blue
3. Soccer | Nick | White
4. Baseball | Mike | Orange
5. Football | Justin | Yellow


I would like the formula to look through both sheets to find exact duplicates of both Columns A + B and then copy Column C's info from where the duplicate is located in Sheet 2 to Column C in Sheet 1. So in the case of the above information Sheet 1/Row 1 would match with Sheet 2/Row 4 and Sheet 1/Row 4 would match with Sheet 2/Row 2.

The output on Sheet 1 would then look like this:

Sheet 1
Column A | Column B | Column C

1. Baseball | Mike | Orange
2. Football | John
3. Soccer | Tim
4. Baseball | Ben | Blue
5. Football | Scott

Any help would be appreciated, sorry for the poor formatting.

[jeffreybrown]

In C2 copied down on Sheet1...

=IFERROR(INDEX(Sheet2!$C$2:$C$6,MATCH(A2&B2,Sheet2!$A$2:$A$6&Sheet2!$B$2:$B$6,0)),"")

IMPORTANT

• This is an array formula
• Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
• If entered correctly, the formula will be enclosed in {brackets}
• Do not enter the {brackets} manually

[broseidon]

Hey Jeff,

Thanks for the quick response, it seems to work perfectly. I really appreciate the help!

[jeffreybrown]

You are very welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.