Hello guys,I hope you can help me and I'll try to explain as much clearly as I can.

So lets say we have two sheets. In both sheets we have like 1700+ rows. Lets assume the sheet2 is correct and we need to compare to sheet 1. In sheet1 and sheet2 we have a product in one column and its code in different.
Lets say:
Product Code
VBP XMZ 1
VBP XMZ 2
KBP 1 A5

So we need to find a code in sheet1 that is united with the wrong product. Like

VBP 1 A5

But for example if there is a code that belongs to some product in sheet2 but it doesnt exist in sheet1 then it is correct. Only need to find that belongs not to the correct product

I hope you'll get it