Check to see if string is anywhere in a column

[newbieVBAwriter]

Hey there ladies and gents,

I would like to write a VBA code that would take the all the cells in a column, column B, and see if all of these different cells are anywhere as a string in column K. The only problem I continue to run into is the fact that there are more or some missing characters in column K than in column B (ex. B2= RSI=24MASI and some cell in K= 1K24MASI) or something along the lines of that. The amount of rows can vary also.

I also looked into writing a formula like this

[COLOR=#000000][FONT=Consolas]=[/FONT][/COLOR][COLOR=#00008B][FONT=Consolas]IF[/FONT][/COLOR][COLOR=#000000][FONT=Consolas]([/FONT][/COLOR][COLOR=#000000][FONT=Consolas]ISNA[/FONT][/COLOR][COLOR=#000000][FONT=Consolas]([/FONT][/COLOR][COLOR=#000000][FONT=Consolas]VLOOKUP[/FONT][/COLOR][COLOR=#000000][FONT=Consolas](<[/FONT][/COLOR][COLOR=#00008B][FONT=Consolas]single[/FONT][/COLOR][COLOR=#000000][FONT=Consolas] column A value[/FONT][/COLOR][COLOR=#000000][FONT=Consolas]>,<[/FONT][/COLOR][COLOR=#000000][FONT=Consolas]entire column K range[/FONT][/COLOR][COLOR=#000000][FONT=Consolas]>,[/FONT][/COLOR][COLOR=#800000][FONT=Consolas]1[/FONT][/COLOR][COLOR=#000000][FONT=Consolas],[/FONT][/COLOR][COLOR=#800000][FONT=Consolas]FALSE[/FONT][/COLOR][COLOR=#000000][FONT=Consolas])),[/FONT][/COLOR][COLOR=#800000][FONT=Consolas]FALSE[/FONT][/COLOR][COLOR=#000000][FONT=Consolas],[/FONT][/COLOR][COLOR=#000000][FONT=Consolas] [/FONT][/COLOR][COLOR=#800000][FONT=Consolas]TRUE[/FONT][/COLOR][COLOR=#000000][FONT=Consolas])[/FONT][/COLOR]

but that returned some interesting N/A's or #NAME errors.

I could really use some guidance/help in writing this.

Also, I am writing this on excel 2003 so some of the newer functions don't apply.

Thank you so much.