Does list 2 values exist somewhere in the list 1 cell?

[popskull]

Hi, I need to find out if any of the list 2 values exists somewhere in the list 1 cells. Below is an example .. The lists will really be many times bigger so I need a formula! The solution I need is a yes or a no against List 1 cells. Many thanks.

Example:

List 1
A2 = NOPOS Ltd WFD REF 38476FH
A3 = 2015095562 MCARE
A4 = 045456AB NOPOS
etc ..

List 2

A2 = 38476
A3 = 45456
A4 = 468281

List 1 Solution ...

B2 = YES
B3 = NO
B4 = YES