Merging two files in excel Closed

Question

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?

ash_perez01 · Answer

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.

JJ · Answer

Great thanks I'll have a look at it.

ash_perez01 · Answer

Dear JJ, 

It's a pleasure to provide you any help. 

Thanks in advance.

Merging two files in excel

3 responses

Similar discussions

Subscribe To Our Newsletter!