Search function with a list

[toadddd]

Hi everyone

I want to search for some specific text string on List 1 that matches with names on List 2

To make it more visual, I have created 2 dummy lists below. Ideally, it would show that row 1 and 2 are TRUE while row 3 is FALSE. Hope this makes sense

Is there a simple function that can do this? Greatly appreciate your help on this. Thanks in advance

List 1
aa;bb;cc
cc;dd;ee
ff;ee;da

List 2
aa
cc
zz
yy
xx

 

[bosco_yip]

Try,

=ISNUMBER(LOOKUP(99,SEARCH($C$11:$C$15,C5)))

Or,

=SUMPRODUCT(COUNTIF(C5,"*"&$C$11:$C$15&"*"))>0

Regards