searching a value

[Chad]

This questoin is probably really easy but I am not sure
how to go about doing this. I would like to set up an IF
statement for a column and have it look for a value
anywhere in a certain field...for example

Column1 Column2
1 yes
12 yes
31 yes
415 yes
568 no
4681 yes

I would want the formula in column2 to display "yes" if
the number 1 is found anywhere in the corrosponding field
in Column1 otherwise to display "no"

Thanks in advance
Chad

 

[Peo Sjoblom]

Assuming your data starts in A3

=IF(ISNUMBER(FIND(1,A3)),"yes","no")

copy down

 

[Paul]

This questoin is probably really easy but I am not sure
how to go about doing this. I would like to set up an IF
statement for a column and have it look for a value
anywhere in a certain field...for example

Column1 Column2
1 yes
12 yes
31 yes
415 yes
568 no
4681 yes

I would want the formula in column2 to display "yes" if
the number 1 is found anywhere in the corrosponding field
in Column1 otherwise to display "no"

Thanks in advance
Chad

=IF(ISNUMBER(FIND(1,A1)),"yes","no")

 

[Chad]

Thanks for the advice I appreciate it. Now for one more
question. How would I go about doing th same thing but
instead of looking for a specific number, I would be
searching for a specific word?

Chad

 

[Mark Graesser]

You would use the same formula, just replace the 1 with your word in parenthesis

=IF(ISNUMBER(FIND("yourword",A1)),"yes","no"

Good Luck
Mark Graesse
(e-mail address removed)

----- Chad wrote: ----

Thanks for the advice I appreciate it. Now for one more
question. How would I go about doing th same thing but
instead of looking for a specific number, I would be
searching for a specific word

Cha