searching a value

  • Thread starter Thread starter Chad
  • Start date Start date
C

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
 
Chad said:
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
Click to expand...

=IF(ISNUMBER(FIND(1,A1)),"yes","no")
 
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
 
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
 
Back
Top