Compare if two cells contain some of the same text

[tropiqz]

Hi Guys,

Is there a way where two cells can be matched on containing some of the same text? I have been using ISNUMBER(SEARCH()) to match but this only matches the whole string.

See the below example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]AMCO[/TD]
[TD]Amco Services[/TD]
[TD]TRUE[/TD]
[/TR]
</tbody>[/TABLE]

using the ISNUMBER(SEARCH()) function will match these and calculate as 'TRUE'.

However is there a way this can be done on some of the below?
[TABLE="width: 500"]
<tbody>[TR]
[TD]PIXELY1[/TD]
[TD]Pixely Berries[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]Langley BS[/TD]
[TD]Langley Systems[/TD]
[TD]FALSE[/TD]
[/TR]
</tbody>[/TABLE]

As you can see they do contain some of the same text but they are still not matching as 'TRUE' - is there a way round this?

Thanks in advance

 

[mole999]

if you used LEFT(***,4) that would match