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!!

Hi,
Maybe like that?
=FILTER($A$1:$A$22,ISNUMBER(SEARCH(H2,$A$1:$A$22)))

Hi, Thank you for replying.

So it has worked to resolve some other issue but my requirement for this particular query was that every row in column A should be checked against the keyword and I should get result in Column B. In this case every keyword is getting separate result, which is why for every keyword I need to run the script and that would not solve my purpose.

I have attached an excel file, please check that. That is how I need a result so that further I can write an if statement and get the desired output.

I'm unclear on what you are wanting, but maybe this will give you what you want. In Cell B2, enter this:

=INDEX($H$2:$H$6,MATCH(TRUE,ISNUMBER(SEARCH($H$2:$H$6,A2)),0))

And copy down.

If this doesn't answer your question, please supply mocked up results of what you expect.

Thank you so much. It has worked.