Search in substring

[Velven]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]b[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]60112650653[/TD]
[TD]60112650653[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]60112750403[/TD]
[TD]60111111111[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]60111111111 / 602222222[/TD]
[TD]60112345678[/TD]
[TD]no[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6015243513[/TD]
[TD]60126384232[/TD]
[TD]no[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]60320320335[/TD]
[TD]60132312351[/TD]
[TD]no[/TD]
[/TR]
</tbody>[/TABLE]

I'm trying to search for the value B in the Column A , If it exists return a yes in C.

Tried using Wildcards but doesn't seems to work if it's an exact match.

 

[Tetra201]

Maybe

=IF(ISNUMBER(FIND(B1,A1)),"Yes","No")

 

[AhoyNC]

Try:
This is an array formula and must be entered with

Excel Workbook
	A	B	C
1	60112650653	60112650653	Yes
2	60112750403	60111111111	Yes
3	60111111111 / 602222222	60112345678	No
4	6015243513	60126384232	No
5	60320320335	60132312351	No
CTRL-SHIFT-ENTER.