Search in substring

[Velven]

	A	b	c
1	60112650653	60112650653	Yes
2	60112750403	60111111111	Yes
3	60111111111 / 602222222	60112345678	no
4	6015243513	60126384232	no
5	60320320335	60132312351	no

<tbody>
</tbody>

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.