help searching text
 

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.

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

--
Regards,

Peo Sjoblom


"Nikko" wrote in message
om...
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.

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

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

//Monika

"Peo Sjoblom" skrev:

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

--
Regards,

Peo Sjoblom


"Nikko" wrote in message
om...
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.