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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

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,108
Messages
5,545,987
Members
410,718
Latest member
ALM1GHTY
Top