Categorize the words using macros

[Latha Mani]

Dear friends

I have listed of words in column A for which i need to put certain code in column B.

If Coulmn A contains words listed in coulmn E then put the category code listed in D to column B


Thanks

[lancer102rus]

Like this?

sample2.xlsx

[:) Sixthsense :)]

In B2 Cell

=INDEX($E$2:$E$10,MATCH("*"&TRIM(A2)&"*",$F$2:$F$10,0))

Or

=LOOKUP(2,1/SEARCH(TRIM(A2),$F$2:$F$10),$E$2:$E$10)

Drag it down...

[Latha Mani]

yes lancer....but Column A may also contain some words attached to it not just salad or soup it may contain veg soup and still i want the category code to be displayed

Thanks

[Latha Mani]

Hi sixthsense

When i tried this formula it shows N/A

[:) Sixthsense :)]

When i tried this formula it shows N/A

No, it will not result #N/A for all the cases, only for the cases where there is no equivalent match

[lancer102rus]

yes lancer....but Column A may also contain some words attached to it not just salad or soup it may contain veg soup and still i want the category code to be displayed

Thanks

There is no such formula. You can solve this only by macros.
But i think that the easiest way is to fill Column E with all variants of food

[Latha Mani]

Yes i need macro to do this..