Match 2 columns if 4 characters are the same

[mde37802]

Hi. I have an excel question. I am needing to put either "yes" or "no" in column F if columns D and E match. I only want to consider them a match if 4 or more characters in a sequence are the same.

For instance:
Column D Column E Column F
Betty@help.com Help brokers Yes
John@liveins.com Help brokers No
Ron@butler.com Butler inc. Yes
Sally@abc.com ABC Comp No
John@bestlife.com John Smith Yes

 

[hrayani]

Hello,

try below

Book1
	A	B	C
1	Column 1	Column 2	Match
2	Betty@help.com	Help brokers	Yes
3	John@liveins.com	Help brokers	No
4	Ron@butler.com	Butler inc.	Yes
5	Sally@abc.com	ABC Comp	No
6	John@bestlife.com	John Smith	Yes
Sheet1 (2)

Cell Formulas
Range	Formula
C2:C6	C2	=IF(LEN(LEFT(B2,FIND(" ",B2,1)-1))>=4,IF(ISNUMBER(SEARCH(LEFT(B2,FIND(" ",B2,1)-1),A2)),"Yes","No"),"No")