Merging two files in excel

Closed
JJ - Dec 29, 2009 at 11:42 PM
 Blocked Profile - Dec 31, 2009 at 01:46 AM
Hello,
I am having the worst time trying to merge two files.

In one sheet i have products with their descriptions, skus, etc.
The other is a sheet that contains categories for each of the products in the first sheet.

So sheet one is set up like this:
itemid   product name  sku     productimage
1           plane       44      http://www.......
2           flower      66      http://www.......</code>


The second sheet has the following

itemcategory    sku
toys              44
garden            66

I would like to combine the two using the sku's as reference so the itemcategory gets inserted in the first sheet according to the sku.

Final sheet (the way i'd like it to be)

itemid   product name  sku      itemcategory   productimage
1        plane          44       toys           http://www.......
2        flower         66       garden        http://www.......</code>


Is there a formula that would do that for me in excel?

3 replies

Blocked Profile
Dec 30, 2009 at 03:39 AM
Dear JJ,

Please find the solution to the difficulty that you

are experiencing through the below Kioskea FAQ

article:

https://ccm.net/faq/4938-how-to-compare-two-excel-sheets-and-combine-unique-data

Thanks.
0
Great thanks I'll have a look at it.
0
Blocked Profile
Dec 31, 2009 at 01:46 AM
Dear JJ,

It's a pleasure to provide you any help.

Thanks in advance.
0