Search a two digit Number in a String in a Cell

[ShlomiUnique]

Good Day all

I have a cell with a string such as 1.2.3.4 and i want to find if this string contains a number appear in other cell, lets say cell $A$1 = 3.
I've able to do it, BUT
when i have a case with a string such as: 1.2.13.4 , it "looks" on the 3 (on $A$1) and returned as if this number is part of the string.
But i want to check if it contain 13 NOT 3.
I being thinking that maybe I should check first the Length on the A1 cell contain the number (3) and then check the cell with the string (1.2.13.4).
could not figure out how to do it....
I've Try the formula SEARCH or even by VBA , InStr(A1,"1.2.13.4"), but with no success....

any help will be appreciated!!!

VBA code will be better, as I need to Loop some other cells as well, for checking (i.e: i need to check the Criteria 3 in other cells with string as well)
Thanks A Lot !!!
Shlomi

 

[AlKey]

Perhaps something like this
Where the text strings in Col A, lookup values in Col B and results in Col C
Enter formula in C1 and copy down

=ISNUMBER(SEARCH("."&B1&".","."&A1&"."))

Excel 2016 (Windows) 32 bit
	A	B	C
1	1.2.13.4	13	TRUE
2	1.2.13.5	5	TRUE
3	1.2.23.6	15	FALSE
4	1.2.16.7	16	TRUE
Sheet3