Forum Discussion
Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With ov...
Hi Excel expert team. I have a Excel formula which had been struggling me for sometime. I really need help to advise for a Vlookup table for my excel chart.
Is this a right place to share my issue?
Is this a right place to share my issue?
Customer Name Cust PO Item Code Product Category 3 Digits Code Returned Value
Example TUM 227.E0119.006 3M (653) 653 Being (227)
1 TUM 332.H0501.001 Ace Glass (108) 108
2 TUM 789.M0400.001 Advantech (110) 110
3 TUM 314.C0508.006 AikMoh (308) 308
4 NTU 376.W0500.004 Analtech (194) 194
5 NTU 168.T0907.009 As One (789) 789
6 Cargene 308.O8136.003 B.Braun (314) 314
7 Kuraray 304.B0609.003 Beatson Bottle (452) 452
8 Kuraray 304.B0609.003 Becton Dickinson (320) 320
9 Kuraray 789.S0600.002 Being (227) 227
10 Kuraray 314.C0508.003 Bel-art (280) 280
11 Kuraray 376.B0101.002 Burkle (116) 116
12 Firmenich 280.T0300.008 Changsha Yingtai (228) 228
13 BR Metals 308.00110.001 Chemoscience (332) 332
Can you advise me the excel formula for above chart by either using vlookup or solutions to match the first 3 digits product code in Item No. column with 3 digits in the bracket of Item code column. Return the match entire item code column into Return value column. Show me the result in the chart too. I had provide the first link as example of the return value. Appreciate for your help in advance.
Example TUM 227.E0119.006 3M (653) 653 Being (227)
1 TUM 332.H0501.001 Ace Glass (108) 108
2 TUM 789.M0400.001 Advantech (110) 110
3 TUM 314.C0508.006 AikMoh (308) 308
4 NTU 376.W0500.004 Analtech (194) 194
5 NTU 168.T0907.009 As One (789) 789
6 Cargene 308.O8136.003 B.Braun (314) 314
7 Kuraray 304.B0609.003 Beatson Bottle (452) 452
8 Kuraray 304.B0609.003 Becton Dickinson (320) 320
9 Kuraray 789.S0600.002 Being (227) 227
10 Kuraray 314.C0508.003 Bel-art (280) 280
11 Kuraray 376.B0101.002 Burkle (116) 116
12 Firmenich 280.T0300.008 Changsha Yingtai (228) 228
13 BR Metals 308.00110.001 Chemoscience (332) 332
Can you advise me the excel formula for above chart by either using vlookup or solutions to match the first 3 digits product code in Item No. column with 3 digits in the bracket of Item code column. Return the match entire item code column into Return value column. Show me the result in the chart too. I had provide the first link as example of the return value. Appreciate for your help in advance.