asking about matching name and sku

N

nik azhar

New Member
Joined
May 19, 2021
Messages
4
Office Version
  1. 2016
hi, i new here
my manager give list of sku to me.
then he ask me to find name represent for the sku.
he also give me all the data sku complete with name.

my question is
can excel matching the sku with name on other sheet
i just want make my jobs faster

tq for your helping
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
Welcome to the MrExcel forum!

It's hard to tell without seeing your sheet, but check out the VLOOKUP function:

Book1
ABCDEF
1SKU Price ProductSKUName
2123$ 1.00Product 2111Product 1
3456$ 2.00Product 4123Product 2
4789$ 3.00Product 6222Product 3
5456Product 4
6777Product 5
7789Product 6
Sheet17
Cell Formulas
RangeFormula
C2:C4C2=VLOOKUP(A2,$E$2:$F$7,2,0)
 
Upvote 0
hi eric,
have a good day

here i attach total all sku and name
and the sku given by manger

tq
all sku
SHORT_SKUITEM_DESCsku need to find item desc
01300488HSG/SP HAN/GEN COLLECTE-SIDE PLATE01300837
01300493HSG/TP HAN/GEN COLLECTE-TEA POT01300853
01300505HSG/DSD HAN/GEN COLLECTE-DIVIDED SAUCE DISH01300971
01300566HPT/OP PLANTINUM OVAL PLATTER01300974
01300568HPT/DSD PLANTINUM DIVIDED SAUCE DISH01301263
01300837532021X6 6PCS BATIK CAKE FORK01300488
01300853SG 118 16LIT. POLYCARBONATE01300493
01300971YN-1143 (G) TOOTHPICK HOLDER01300505
01300974IN-1143 (Y) TOOTHPICK HOLDER01301923
01301263C7291-12 2CM 12`S FOOD WARMER01302903
01301923502021 OXFORD 2PCS CAKE FORK01303026
013029036405 7OZ COVERED SUGAR BOWL
01303026535021 REFLECTION 4 PCS CAKE FORK
01303055526021 KARINA 4 PCS CAKE FORK
01303194IN-1144 CHOPSTICK STAND GREEN
013049079386 WINE THERMOMETER
013049429048 ACRYLIC WINE COOLER
01305168ES-2 FAMILIA SERIES FOR SALT
01305172ES-3 FAMILIA SERIES FOR TOOTHPICKS
01305444WRM 1000 1L H/FLASK
01305445WRM 1300 1.3L H/FLASK
01305453WGM 2200 2.2L AIR POT
01305555PLACEMAT (ASSORTED DESIGN)
01305754ALIYA SALAD BOWL 25CM
01306845DESSERT FORK 100PCS
01307402WFS3000 3.0L S/S AIRPOT
01307403WFM2200 2.2L FLORAL AIRPOT
01309312AS-2233 PASTY TOOTHPICK HOLDER BLUE
 
Upvote 0
Just like I showed you before. Just change the ranges to match your workbook:

Book1
ABCDE
1all sku
2SHORT_SKUITEM_DESCsku need to find item desc
31300488HSG/SP HAN/GEN COLLECTE-SIDE PLATE1300837532021X6 6PCS BATIK CAKE FORK
41300493HSG/TP HAN/GEN COLLECTE-TEA POT1300853SG 118 16LIT. POLYCARBONATE
51300505HSG/DSD HAN/GEN COLLECTE-DIVIDED SAUCE DISH1300971YN-1143 (G) TOOTHPICK HOLDER
61300566HPT/OP PLANTINUM OVAL PLATTER1300974IN-1143 (Y) TOOTHPICK HOLDER
71300568HPT/DSD PLANTINUM DIVIDED SAUCE DISH1301263C7291-12 2CM 12`S FOOD WARMER
81300837532021X6 6PCS BATIK CAKE FORK1300488HSG/SP HAN/GEN COLLECTE-SIDE PLATE
91300853SG 118 16LIT. POLYCARBONATE1300493HSG/TP HAN/GEN COLLECTE-TEA POT
101300971YN-1143 (G) TOOTHPICK HOLDER1300505HSG/DSD HAN/GEN COLLECTE-DIVIDED SAUCE DISH
111300974IN-1143 (Y) TOOTHPICK HOLDER1301923502021 OXFORD 2PCS CAKE FORK
121301263C7291-12 2CM 12`S FOOD WARMER13029036405 7OZ COVERED SUGAR BOWL
131301923502021 OXFORD 2PCS CAKE FORK1303026535021 REFLECTION 4 PCS CAKE FORK
1413029036405 7OZ COVERED SUGAR BOWL
151303026535021 REFLECTION 4 PCS CAKE FORK
161303055526021 KARINA 4 PCS CAKE FORK
171303194IN-1144 CHOPSTICK STAND GREEN
1813049079386 WINE THERMOMETER
1913049429048 ACRYLIC WINE COOLER
201305168ES-2 FAMILIA SERIES FOR SALT
211305172ES-3 FAMILIA SERIES FOR TOOTHPICKS
221305444WRM 1000 1L H/FLASK
231305445WRM 1300 1.3L H/FLASK
241305453WGM 2200 2.2L AIR POT
251305555PLACEMAT (ASSORTED DESIGN)
261305754ALIYA SALAD BOWL 25CM
271306845DESSERT FORK 100PCS
281307402WFS3000 3.0L S/S AIRPOT
291307403WFM2200 2.2L FLORAL AIRPOT
301309312AS-2233 PASTY TOOTHPICK HOLDER BLUE
Sheet2
Cell Formulas
RangeFormula
E3:E13E3=VLOOKUP(D3,$A$3:$B$30,2,0)
 
Upvote 0
nik azhar said:
hi eric,
have a good day

here i attach total all sku and name
and the sku given by manger

tq
all sku
SHORT_SKUITEM_DESCsku need to find item desc
01300488HSG/SP HAN/GEN COLLECTE-SIDE PLATE01300837
01300493HSG/TP HAN/GEN COLLECTE-TEA POT01300853
01300505HSG/DSD HAN/GEN COLLECTE-DIVIDED SAUCE DISH01300971
01300566HPT/OP PLANTINUM OVAL PLATTER01300974
01300568HPT/DSD PLANTINUM DIVIDED SAUCE DISH01301263
01300837532021X6 6PCS BATIK CAKE FORK01300488
01300853SG 118 16LIT. POLYCARBONATE01300493
01300971YN-1143 (G) TOOTHPICK HOLDER01300505
01300974IN-1143 (Y) TOOTHPICK HOLDER01301923
01301263C7291-12 2CM 12`S FOOD WARMER01302903
01301923502021 OXFORD 2PCS CAKE FORK01303026
013029036405 7OZ COVERED SUGAR BOWL
01303026535021 REFLECTION 4 PCS CAKE FORK
01303055526021 KARINA 4 PCS CAKE FORK
01303194IN-1144 CHOPSTICK STAND GREEN
013049079386 WINE THERMOMETER
013049429048 ACRYLIC WINE COOLER
01305168ES-2 FAMILIA SERIES FOR SALT
01305172ES-3 FAMILIA SERIES FOR TOOTHPICKS
01305444WRM 1000 1L H/FLASK
01305445WRM 1300 1.3L H/FLASK
01305453WGM 2200 2.2L AIR POT
01305555PLACEMAT (ASSORTED DESIGN)
01305754ALIYA SALAD BOWL 25CM
01306845DESSERT FORK 100PCS
01307402WFS3000 3.0L S/S AIRPOT
01307403WFM2200 2.2L FLORAL AIRPOT
01309312AS-2233 PASTY TOOTHPICK HOLDER BLUE
Click to expand...

Obviously , ERIC has given you the best solution , however You can also try index n match
 
Upvote 0
Obviously , ERIC has given you the best solution , however You can also try index n match

Book1
ABCDE
2SHORT_SKUITEM_DESCsku need to find item descOutput
31300488HSG/SP HAN/GEN COLLECTE-SIDE PLATE1300837532021X6 6PCS BATIK CAKE FORK
41300493HSG/TP HAN/GEN COLLECTE-TEA POT1300853SG 118 16LIT. POLYCARBONATE
51300505HSG/DSD HAN/GEN COLLECTE-DIVIDED SAUCE DISH1300971YN-1143 (G) TOOTHPICK HOLDER
61300566HPT/OP PLANTINUM OVAL PLATTER1300974IN-1143 (Y) TOOTHPICK HOLDER
71300568HPT/DSD PLANTINUM DIVIDED SAUCE DISH1301263C7291-12 2CM 12`S FOOD WARMER
81300837532021X6 6PCS BATIK CAKE FORK1300488HSG/SP HAN/GEN COLLECTE-SIDE PLATE
91300853SG 118 16LIT. POLYCARBONATE1300493HSG/TP HAN/GEN COLLECTE-TEA POT
101300971YN-1143 (G) TOOTHPICK HOLDER1300505HSG/DSD HAN/GEN COLLECTE-DIVIDED SAUCE DISH
111300974IN-1143 (Y) TOOTHPICK HOLDER1301923502021 OXFORD 2PCS CAKE FORK
121301263C7291-12 2CM 12`S FOOD WARMER13029036405 7OZ COVERED SUGAR BOWL
131301923502021 OXFORD 2PCS CAKE FORK1303026535021 REFLECTION 4 PCS CAKE FORK
1413029036405 7OZ COVERED SUGAR BOWL
151303026535021 REFLECTION 4 PCS CAKE FORK
161303055526021 KARINA 4 PCS CAKE FORK
171303194IN-1144 CHOPSTICK STAND GREEN
1813049079386 WINE THERMOMETER
1913049429048 ACRYLIC WINE COOLER
201305168ES-2 FAMILIA SERIES FOR SALT
211305172ES-3 FAMILIA SERIES FOR TOOTHPICKS
221305444WRM 1000 1L H/FLASK
231305445WRM 1300 1.3L H/FLASK
241305453WGM 2200 2.2L AIR POT
251305555PLACEMAT (ASSORTED DESIGN)
261305754ALIYA SALAD BOWL 25CM
271306845DESSERT FORK 100PCS
281307402WFS3000 3.0L S/S AIRPOT
291307403WFM2200 2.2L FLORAL AIRPOT
301309312AS-2233 PASTY TOOTHPICK HOLDER BLUE
Sheet1
Cell Formulas
RangeFormula
E3:E13E3=INDEX(B:B,MATCH(D3,A:A,0))
 
Upvote 0
Rahul1987 said:
Obviously , ERIC has given you the best solution , however You can also try index n match

Book1
ABCDE
2SHORT_SKUITEM_DESCsku need to find item descOutput
31300488HSG/SP HAN/GEN COLLECTE-SIDE PLATE1300837532021X6 6PCS BATIK CAKE FORK
41300493HSG/TP HAN/GEN COLLECTE-TEA POT1300853SG 118 16LIT. POLYCARBONATE
51300505HSG/DSD HAN/GEN COLLECTE-DIVIDED SAUCE DISH1300971YN-1143 (G) TOOTHPICK HOLDER
61300566HPT/OP PLANTINUM OVAL PLATTER1300974IN-1143 (Y) TOOTHPICK HOLDER
71300568HPT/DSD PLANTINUM DIVIDED SAUCE DISH1301263C7291-12 2CM 12`S FOOD WARMER
81300837532021X6 6PCS BATIK CAKE FORK1300488HSG/SP HAN/GEN COLLECTE-SIDE PLATE
91300853SG 118 16LIT. POLYCARBONATE1300493HSG/TP HAN/GEN COLLECTE-TEA POT
101300971YN-1143 (G) TOOTHPICK HOLDER1300505HSG/DSD HAN/GEN COLLECTE-DIVIDED SAUCE DISH
111300974IN-1143 (Y) TOOTHPICK HOLDER1301923502021 OXFORD 2PCS CAKE FORK
121301263C7291-12 2CM 12`S FOOD WARMER13029036405 7OZ COVERED SUGAR BOWL
131301923502021 OXFORD 2PCS CAKE FORK1303026535021 REFLECTION 4 PCS CAKE FORK
1413029036405 7OZ COVERED SUGAR BOWL
151303026535021 REFLECTION 4 PCS CAKE FORK
161303055526021 KARINA 4 PCS CAKE FORK
171303194IN-1144 CHOPSTICK STAND GREEN
1813049079386 WINE THERMOMETER
1913049429048 ACRYLIC WINE COOLER
201305168ES-2 FAMILIA SERIES FOR SALT
211305172ES-3 FAMILIA SERIES FOR TOOTHPICKS
221305444WRM 1000 1L H/FLASK
231305445WRM 1300 1.3L H/FLASK
241305453WGM 2200 2.2L AIR POT
251305555PLACEMAT (ASSORTED DESIGN)
261305754ALIYA SALAD BOWL 25CM
271306845DESSERT FORK 100PCS
281307402WFS3000 3.0L S/S AIRPOT
291307403WFM2200 2.2L FLORAL AIRPOT
301309312AS-2233 PASTY TOOTHPICK HOLDER BLUE
Sheet1
Cell Formulas
RangeFormula
E3:E13E3=INDEX(B:B,MATCH(D3,A:A,0))
Click to expand...
HI RAHUL..

thank you...

i did it...

but how to protect the formula on the cell to prevent edit by others person
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Help with scanning barcodes into an excel invoice
2
Replies
12
Views
1K
RoryA
RoryA
D
  • Question Question
Remove matching rows with pause function
Replies
1
Views
182
alansidman
A
N
  • Question Question
EXCEL VBA COMBO BOX/DROP DOWN LIST
Replies
1
Views
62
Peter_SSs
Peter_SSs
D
  • Question Question
Formula "INDIRECT" does not work
Replies
6
Views
214
deri_b
D
A
  • Question Question
Dynamically add new rows via VBA when using IFERROR TEXTJOIN and FILTER formulas from Table?
Replies
0
Views
517
AlfredDB
A

Forum statistics

Threads
1,223,888
Messages
6,175,212
Members
452,618
Latest member
Tam84

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top