Hi,

I have to compare 2 columns, where one cell of Column B matches to the other cell of Column C.
I applied =IF(B2=C2, "Yes", "No"), this formula gives me the result only for exact match. Atleast 4 continous character matches also I should consider as same and display Yes in Column A. Could anyone help me to get the following output:

eg., Column A|Column B|Column C

Yes |Peter|Peter Ltd
Yes |Robinson|Mark robinson
Yes |Smith|Smit
No |Jack|Jim
Yes |tommy|ktommyson

Thanks
John