help searching text

[Nikko]

Thanks in advance for your help.

In column 1, I have a text string which includes a numeral somewhere
in it. In column 2, I have numbers.

In column 3, I want to search the text in string in column 1 to see if
there is a "6" anywhere in the text and, if there is, I want to place
the number in column 2 into the current cell.

I thought a simple =if(A1 = "*6*", C1 = B1, 0) would work but it
always returns FALSE and, therefore, zero.

 

[Peo Sjoblom]

=IF(COUNTIF($A$1:$A$10,"*"&B1&"*")>0,B1,"Not Found")

 

[Guest]

....and continuing Peos example I think you can use:

=IF(COUNTIF(A1,"*"&6&"*")>0,B1,"Not Found")

//Monika

"Peo Sjoblom" skrev: