Determining if two columns values are equal/close

[Guest]

I have two columns of data as seen below:

ColA ColB
1 Acme Acme Inc.
2 XYZ ABC
3 Seal Seals

I need to define in Col C whether or not data from col A and B are equal or
close to being equal by using a True/False result. For example, row 1 and 3
would be a match. However row 2 would not.

 

[Roger Govier]

Hi

In column C
=ISNUMBER(FIND(A1,B1))
will return True for rows 1 and 3

FIND is case sensitive.
If you are not concerned about case then use the non case sensitive
Search function
=ISNUMBER(SEARCH(A1,B1))

 

[Guest]

That helps Roger. Any insight into row 4's predicament as I want it to return
a true value but the formulas below return a false value. Thanks for your
help.

ColA ColB
1 Acme Acme Inc.
2 XYZ ABC
3 Seal Seals
4 Seals Seal

 

[Guest]

maybe

=OR(ISNUMBER(FIND(G25,H25)),ISNUMBER(FIND(H25,G25)))

 

[Guest]

I used

=IF(AND(TEXT(ISNUMBER(SEARCH(A2,B2)),0)="false",
TEXT(ISNUMBER(SEARCH(B2,A2)),0)="false"),"FALSE", "TRUE")

and it seems to work. Thanks Roger and Mike for your assistance and have a
blessed day.