comparing columns

[Rnash]

I have a three column list.
Column a is a unique number
Column B contains an original list
Column C contains the original list with corrections

I need a formula to compare that B and C correspond.

Here's an example:

22687 ABBEY REGINA S REGINA S ABBEY

There is probably a tip for this, but I can't seem to find it.

[NBVC]

you mean?

=B2=C2

this will return TRUE if they are the same? (not case sensitive though).

If you want case sensitive matching..

=EXACT(B2,C2)

[Rnash]

Well, the problem is that not all of the text string matches in the corrected. Is there a way to compare to make sure there is at least one of the words matches somewhere is the text for column C that is contained in column B.

example:
JOHNSTON PAUL L TRUSTEE became MAX D KENNEDY TRUSTEE

Somehow, I lost the correction that should be Paul L Johnston Trustee

So, I want to compare to make sure there is some match between the two columns like "johnston" appears in column B and either does or does not in column C

[NBVC]

So you just want to see that Johnston appears in C or not... so the first "word".

It is not a simple task to see if any word in B is in string C or vice versa...

[Rnash]

Yes, it can be based on the "first" word in column B

[NBVC]

Then:

=ISNUMBER(SEARCH(LEFT(B2,FIND(" ",B2)-1),C2))

[Rnash]

Didn't seem to work. this one still returned true:

HURD E BERNARD JR there are not likeness: KERMIT G KALB TRUSTEE

[NBVC]

I got FALSE.. are you sure you are reference the correct cells?