I have 2 worksheets, both have the same columns, description, price, department, and custom sku. Worksheet 1 has all the custom skus, worksheet 2 does not. I would like to match the "Description" between the two worksheets, if a match is found, i would like to fill worksheet 2 with that custom sku. Basically, If description matches, import custom sku to worksheet 2. I would just copy paste everything, but i have over 14k items, not all items will have a custom sku as some products are new, so i would like to do a match to refelect what i have in my current inventory.
Can someone help me with this please?
Thank you in advance
Sample:
Worksheet 1:
Worksheet 2:
Can someone help me with this please?
Thank you in advance
Sample:
Worksheet 1:
Description | Department | Price | Custom SKU |
Gear Type 1 | Auto | 29.95 | 5542 |
Gear Type 2 | Auto | 32.95 | 5562 |
Worksheet 2:
Description | Department | Price | Custom Sku |
Gear Type 1 | Auto | 29.95 | |
Gear Type 2 | Auto | 32.95 |