Searching matched keyword is not working here

Greetings,

I have a excel, column C contains a list of keywords, all rows in column A are to be checked with Column C and if A contains any keyword in C (column head as Keyword), Column B will be marked as True.

What I used in B is: =SUMPRODUCT(--ISNUMBER(SEARCH(Keyword,A2)))>0

Not working.

Sample excel attached here for the convenience.

Thank you very much.

Either use

Formula:

Please Login or Register  to view this content.

Or make C2:C10 a named range called Keyword

Thank you, how to make C2:C10 a named range called Keyword?

Select C1:C10 then on the formula tab click "Create from selection", check "Top row" if not already checked, OK.

Thank you.

You're welcome

HI Fluff13,
can you please tell me, when i do space on any cell between C2 to C13 formula return TRUE for all. please see the snap here.
Thanks

@majidsiddique

As per forum rules please do not "hijack" other peoples threads.
You need to start a thread of your own, if you have not already done so.

Hi Fluff13,
OK noted, but i just only share you a very little issue. otherwise i don't want to hijack this.
Thanks

Hi AliGW,
Noted.
Thanks