Search for text string that matches with a name 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

 

[Domenic]

A1:D6

[TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl63, width: 64"]List 1[/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"]List 2[/TD]
[/TR]
[TR]
[TD="class: xl63"]aa;bb;cc[/TD]
[TD="class: xl63, align: center"]TRUE[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]aa[/TD]
[/TR]
[TR]
[TD="class: xl63"]cc;dd;ee[/TD]
[TD="class: xl63, align: center"]TRUE[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]cc[/TD]
[/TR]
[TR]
[TD="class: xl63"]ff;ee;da[/TD]
[TD="class: xl63, align: center"]FALSE[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]zz[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]yy[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]xx[/TD]
[/TR]
</tbody>[/TABLE]

B2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=OR(ISNUMBER(SEARCH(";"&$D$2:$D$6&";",";"&A2&";")))

Hope this helps!