If match from different worksheet, import SKU.

i8ur4re

Board Regular
Joined
Mar 1, 2015
Messages
97
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:

DescriptionDepartmentPriceCustom SKU
Gear Type 1Auto29.955542
Gear Type 2Auto32.955562

Worksheet 2:

DescriptionDepartmentPriceCustom Sku
Gear Type 1Auto29.95
Gear Type 2Auto32.95
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

KOKOSEK

Board Regular
Joined
Apr 8, 2019
Messages
226
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Into D2 on Worksheet2:
Code:
=VLOOKUP(Worksheet2!A2,Worksheet1!A:D,4,0)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,652
Messages
5,549,206
Members
410,905
Latest member
Extjel
Top