How to categories a list of items

[Angie_]

Hi

I have a list of items, but I need to categories it accordingly at Col B.
May I know which formula to use so that it will read the cell text as a word but not by the character?

Thank you.

[queuesef]

Use lookup table (vLookup). I'm guessing that you only need it for the first part of the item (before the blank space)? If this is true, create a list of the unique Items (you probably can get rid of the text after the 'Sit', 'Siti', 'Siii'. So perhaps on another tab you could have your lookup table: Column A = item Number & Column B Category and put in vLookup formula in the Category. If you upload your example, I could show you.

[Fluff13]

Hi & welcome to the board.
How about

Please Login or Register  to view this content.

[kvsrinivasamurthy]

In E2 then copy down.

=VLOOKUP(D2&"*",$A$2:$B$4,2,0)