Determining if two columns values are equal/close
 

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.

Determining if two columns values are equal/close
 

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))

--
Regards

Roger Govier


"GDCross" wrote in message
...
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.

Determining if two columns values are equal/close
 

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


"Roger Govier" wrote:

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))

--
Regards

Roger Govier


"GDCross" wrote in message
...
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.

Determining if two columns values are equal/close
 

maybe

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

"GDCross" wrote:

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.

Determining if two columns values are equal/close
 

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.

"GDCross" wrote:

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


"Roger Govier" wrote:

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))

--
Regards

Roger Govier


"GDCross" wrote in message
...
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.