separate the word in another column based on the category

[jc83ph]

Hi,

I need your help. I have excel file. I need the formula for display by category found in the description. If the category found in description automatic display in column B like, necklace, ring, earrings and more).

See attached the excel file sample.

Thanks advance for your help.

[davsth]

You need to give a fuller description

can only one category appear on a line. Is the key word always the last of first word in the description.
how many categories will there be?

=IF(COUNTIF(A2,"*bracelet*"),"bracelet",IF(COUNTIF(A2,"*necklace*"),"necklace")) work aand could be extended to more categories, but a lookup of the first or last word against a table would be more efficient if there are lots of categories and this is where the description appears