HELP HELP HELP! assign value to a cell

A

arkashon

New Member
Joined
Mar 18, 2014
Messages
12
I have a list of part numbers and need to categorize them accordingly
for example certain part numbers have same class by which i sort, so my question is how to assign those class to the part numbers accordingly.

If you need more info I can always provide such thing just respond.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Sort by date Sort by votes
arkashon said:
I have a list of part numbers and need to categorize them accordingly
for example certain part numbers have same class by which i sort, so my question is how to assign those class to the part numbers accordingly.

If you need more info I can always provide such thing just respond.
Click to expand...

I'm a fan of downloading links to your data or examples
 
Upvote 0
Thank you so much for such a fast acting!

Well here is the full thing.
74 unique part number:


Which could be classified by 5 basic letters such L, H, O, B, S.
My task is to make a formula that would assign letter according to the part number, I have done it already manually in order to have a reference but I need it to have a continuous tracking since those part number will track sales.
I have tried using vlookup, and could not figure it out
Also IF did not work for me as well
 
Last edited by a moderator:
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Question
Fill in missing data based on another cell
Replies
3
Views
140
dreid1011
dreid1011
edge37
  • Question
Shift down content of range of row cells in Sheet 1 when new data is entered in Sheet 2.
Replies
0
Views
271
edge37
edge37
C
  • Question
Repetitive ”randomly” assigning/selecting team members for a task based on previous number of selections/assignments.
Replies
0
Views
343
ciprinitu
C
J
  • Question
Loop, calculate and copy results
Replies
1
Views
297
OaklandJim
O
T
  • Solved
Weighted lottery help?
2
Replies
14
Views
2K
bebo021999
B

Forum statistics

Threads
1,214,973
Messages
6,122,534
Members
449,088
Latest member
RandomExceller01

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