Formula if Cell A contains any number in Cell B.

[wedding]

Hi I am currently learning and Iwill make this simple:

If Cell A = 2

If Cell B = 9,10,11,12

If Cell A dont contain any numbers in B then Cell C will = +1
If Cell A dont contain any numbers in B then Cell C will = -1

My I know the formula to Cell C? Thanks Guys for the great help in the forums!

Just to add, the values in Cell A and Cell B are from a formula so there are always different.

 

[DonkeyOte]

I think the formula in post # 2 is sufficient (with revised values)

ie normalise both strings with common delimiter simultaneously - no need for multiple searches.

 

[wedding]

Is it possible if I search A1:A15 to B1? B1 will contain the four numbers.