How to assign categories to multiple duplicates?

Rob700

New Member
Joined
Apr 3, 2014
Messages
3
The snippit veiw spreadsheet below shows the total sales of products for 2013.

Column G displays the product codes that have been sold (there are duplicates throughout as the data is compiled of the individual orders)
I would like to segment the products into their relevant categories in column ‘I’.

Question:

How do I assign a category to every product in column ‘I’?

I think I would somehow need to list all of the product codes (minus duplicates) then assign the categories to each individual product in column ‘I’

I would then need the duplicates in column ‘G’ to be assigned to their appropriate category in column ‘I’

e.g. all of the ‘ER32SET’s in column ‘G’ should display ‘cutting tools’ in column ‘I’?

I need to do this for every product in column ‘G’

Your help would be greatly appreciated. A step by step guide would be great! I am an excel novice!

Stock CodeShort DescriptionProduct category
BT40ER25BT40 ER Chuck Range
ER25SETER Collets (class2)
ER25SETER Collets (class2)
ER32SETER Collets (Class2)
ER32SETER Collets (Class2)
ER16SETER Collets (Class2)
ER25SETER Collets (class2)
ER32SETER Collets (Class2)
ER3210ER Collects(Classs 2
ER3212ER Collets (Class2)
ER3216ER Collets (Class2)
ER326ER Collets (Class 2)
ER32SETER Collets (Class2)
ER3211Gurkan ER32 11mm Col
ER3213Gurkan ER32 13mm Col
ER3214Gurkan ER32 14mm Col
ER324Gurkan ER32 4mm Coll
ER325Gurkan ER32 5mm Coll
ER327Gurkan ER32 7mm Coll
ER328Gurkan ER32 8mm Coll
ER329Gurkan ER32 9mm Coll
BT40ER32BT40 ER Chuck Range
BT40ER32BT40 ER Chuck Range
ER166ER Collets (Class2)
ER112ER 11 Collet 2mm
01-108-10NBMixed Quality Wipers
03-315-10NBWhite Sheeting
03-316-5White Sheeting
0901Aerosol White Linema
0902Aerosol Red Linemark
0904Aerosol Blue Linemar
5084918HM BRUSH CLEANER & T
5084918HM BRUSH CLEANER & T
5084845Hammerite 2.5Ltr Smo
5084845Hammerite 2.5Ltr Smo
5084918HM BRUSH CLEANER & T
5084921Hammerite 2.5Ltr Thi
5084918HM BRUSH CLEANER & T

<colgroup><col><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

hippiehacker

Well-known Member
Joined
Aug 2, 2011
Messages
1,911
you should create a list with product/categories on another sheet and do a vlookup to this table

otherwise how do you know under which category is which Product number?
 

Rob700

New Member
Joined
Apr 3, 2014
Messages
3
you should create a list with product/categories on another sheet and do a vlookup to this table

otherwise how do you know under which category is which Product number?

Thank-you for your speedy response.

How do I create a list of individual products? I would need to remove the duplicates.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,471
Messages
5,636,510
Members
416,919
Latest member
twc2c

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
Top