how do i compare a Cell A1 in Worksheet 1 to the whole Column B in Worksheet
2 to see if part of any of the contents in Cell A are anywhere in the list in
Column B.

i.e. Cell A1 for Worksheet 1 = hlj104 and the list of values in worksheet 2
Column B read:
B1: ID=swk149
B2: ID=ldj322
B3: ID=ism572
B4: ID=hlj104
B5: ID=wkl294

i need it to pick up and locate hlj104, now i've tried the
=OR(EXACT(A1,'Worksheet2'!$B$1:$B:$5)) but its not exact cause the ID= is in
front of the userid on worksheet2. so how can i find that on id,in a couple
thousand rows on the other worksheet. thanks in advance...