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

List 1			List 2
aa;bb;cc	TRUE		aa
cc;dd;ee	TRUE		cc
ff;ee;da	FALSE		zz
			yy
			xx

<tbody>
</tbody>

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

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

Hope this helps!