Excel: Search two strings in two columns

You cannot compare it with = sign.

You need to use:

For partial recognition:

=ISNUMBER(SEARCH(B1,A1))

For exact recognition:

=EXACT(C2,F2)

Make sure to trim cell before comparing if you are using EXACT function or otherwise you are going to get bad results.