Formula to find partial string in Cell (Please help)

[ckolawall]

Column A
BKN
NET
CBT
RJK
FVS
KLF
KLFO
KLMF


Column B
BKN - Body Kean North land #23899

Column a has a list of reference cells, basically if Cell B1 contains any of the values is Column A. I want it to be marked true.
I tried using index and search but no prevail please help

[vlady]

is the dash or space always there in column B strings
=IF(COUNTIF(A2:A9,TRIM(LEFT(B2,FIND("-",B2,1)-1)))>0,TRUE,FALSE)
or you can use the space replacing the dash inside the formula (bold part)

[peraxhil]

If the first 3 positions always contain the value you wish to search for in your lookup table, then this can be handled with a vlookup. Set up a range name for your lookup table. For now, I will assume the lookup table is A1.a10.

Then the formula in C1 is -- assuming the item to be looked up is in B1:

=if(isna(vlookup(left(b1,3),a1:a10,1,false)),false, true)

[ckolawall]

No the problem is that its not always the first 3 letters sometimes its within like below

NORTH BKN Land kener brand

[benishiryo]

hi ckolawall, try:
=ISNUMBER(LOOKUP(2^15,SEARCH($A$2:$A$9,B2)))

[ckolawall]

@BENISHIRYO-
Your a king among men

Thank you all for the quick replies,