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 strings are anywhere as a string in column K and tell me where it exists in the respective row in column L. 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:
=IF(ISNA(VLOOKUP(<single column A value>,<entire column K range>,1,FALSE)),FALSE,TRUE)
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.