Search each cell from the whole column and if matched return some value (True/False)

Hi, I have attached an excel file, where in there are 2 columns.

1. Named as category
2. Named as Keyword.

I want a code which is return against each category but it should match a word mentioned in keyword column as shown in excel.

I had a code return with
ISNUMBER(SEARCH(substring,text))
But this is not helping and solving my issue since I need to find word from the keyword column only and list would be very long. While the search formula I am using needs text and not allowing me to select whole column.


Please its urgent!!