I have the below table:

Now, I want to check if the subject is having any of the text present in data (col F)

I used:-

=VLOOKUP(A2&"*",F:F,1,0)

But it is giving #N/A.

CodePudding user response：

Try:

Formula in B2:

=SUM(COUNTIF(A2,F$2:F$3&"*"))>0

Edit:

=SUM(COUNTIF(A2,F$2:INDEX(F:F,MATCH("ZZZ",F:F))&"*"))>0