Merging two files in excel

[Closed]
Report
-
 Blocked Profile -
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


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.
Great thanks I'll have a look at it.

Dear JJ,

It's a pleasure to provide you any help.

Thanks in advance.