Hi All,
I am currently trying to match 2 lists so i can transfer data from one to the other, the problem i am having is that some of the products have the exact same sku but a different product title, and in both lists they are slightly different and theyre is nothing unique about each one of for me to be able to write a formula about (that i can think of) i do not know how to do macro's so i am unsure if this would help.
Also i should note the spreadsheet is 18500 lines long and as i'm currently going through this manually you can see why im hoping someone can help or atleast lend some advice.
example -
Sheet 1
SKU1 - 1234
SKU2 - 1234.1
Product Title
#1 Volkswagen Tiguan Engine Mount
#2 Volkswagen Tiguan Engine Mount
SKU1 - 1234
SKU2 - 1234.1
Product Title
#1 Volkswagen golf Engine Mount
#2 Volkswagen golf Engine Mount
Sheet 2
SKU1 - 1234
SKU2 - 1234.1
Product Title
#1 Volkswagen Tiguan 2007 Engine Mount
#2 Volkswagen Tiguan 2007 Engine Mount
SKU1 - 1234
SKU2 - 1234.1
Product Title
#1 Volkswagen golf 2007 Engine Mount
#2 Volkswagen golf 2007 Engine Mount
Ideally i need something that will be able to look up one list and then put my other list in the same order so i can just copy it across, Going through this sheet manually is killing me and really slowing down my business
Thanks in advance for any help
I am currently trying to match 2 lists so i can transfer data from one to the other, the problem i am having is that some of the products have the exact same sku but a different product title, and in both lists they are slightly different and theyre is nothing unique about each one of for me to be able to write a formula about (that i can think of) i do not know how to do macro's so i am unsure if this would help.
Also i should note the spreadsheet is 18500 lines long and as i'm currently going through this manually you can see why im hoping someone can help or atleast lend some advice.
example -
Sheet 1
SKU1 - 1234
SKU2 - 1234.1
Product Title
#1 Volkswagen Tiguan Engine Mount
#2 Volkswagen Tiguan Engine Mount
SKU1 - 1234
SKU2 - 1234.1
Product Title
#1 Volkswagen golf Engine Mount
#2 Volkswagen golf Engine Mount
Sheet 2
SKU1 - 1234
SKU2 - 1234.1
Product Title
#1 Volkswagen Tiguan 2007 Engine Mount
#2 Volkswagen Tiguan 2007 Engine Mount
SKU1 - 1234
SKU2 - 1234.1
Product Title
#1 Volkswagen golf 2007 Engine Mount
#2 Volkswagen golf 2007 Engine Mount
Ideally i need something that will be able to look up one list and then put my other list in the same order so i can just copy it across, Going through this sheet manually is killing me and really slowing down my business
Thanks in advance for any help