How to Combine two sets of data in excel

**Jchhoule** · 05-09-2012, 04:07 PM

Hello, i am having an issue combine to sheets of data.

The first looks like this:

Item Items Sold Item Code
A 1 B700
B 3 B710
C 2 B712
D 4 B714
E 7 B715

And the second like this:

Item Code
B700 MH-40542 MH-44627 MH-62045 MH-13999 MH-19462
B710 MH-13999 B700 MH-44627
B712 MH-44627 MH-13999
B714 MH-13999 B700 MH-44627
B715 MH-13999 B700 MH-44627

Both lists are very long and i need to take the second and combine it with the first so that all of the items on the second show up next to their corresponding item on the same row.

For example, i want the first to look like this:

Item Items Sold Item Code
A 1 B700 MH-40542 MH-44627 MH-62045 MH-13999 MH-19462

Thank you in advance for any help!

**Cutter** · 05-09-2012, 04:08 PM

Use the VLOOKUP() function:

http://www.excelfunctions.net/ExcelVlookup.html

**Jchhoule** · 05-10-2012, 12:50 PM

Thanks for the help, but i cannot get it to work. I have tried everything i can think of. I am attaching the file. If someone could look at it and tell me what im doing wrong. I would greatly appreciate the help!

**Cutter** · 05-10-2012, 02:47 PM

Try this in cell D2 (and copied over and down as far as you need):

=IF(ISNA(VLOOKUP($C2,Sheet2!$A:B, COLUMN(B1), 0)),"",VLOOKUP($C2,Sheet2!$A:B, COLUMN(B1), 0)&"")

or

=IF(ISNUMBER(MATCH($C2,Sheet2!$A:$A,0)),INDEX(Sheet2!B:B,MATCH($C2,Sheet2!$A:$A,0))&"","")