I'm trying to compare to columns to see if they have any of the same entries
but the data is not totally exact in both columns.

For example I have in column A a value of "211000" and in column B I have a
value of "211000-1". How can I have it compare the two and only look at the
first 6 characters of column B? I want to put a "1" in next to the column B
value to show that it exists in column A. Now Column A has 538 entries in it
and Column B has 24 in it. So I want it to search the entire listing in
column A and have it put a "1" next to the value in column B to show that it
does exist in column A. Hope this all makes sense. :)