Certain words in cells

[blacktour]

I have a column of cells that are inventory descriptions. A bunch of them have "helmet" in the description somewhere. How can I make the next column over say Yes or No as to whether the word "helmet" is in it.

=if(A1=helmet somwhere in cell, YEs, NO)

Thanks in advance.

 

[clayv]

Try

=IF(ISERROR(SEARCH("helmet",A1)),"No","Yes")

 

[blacktour]

works perfect thanks alot for your quick reply!

 

[blacktour]

I was trying to further use this formula so it will pick out helmet and suit.

=IF(SEARCH("Helmet",A6),"Helmet",IF(SEARCH("Suit",A6),"Suit","Other"))

That does not work?

Thanks.

 

[jolivanes]

Could you not use the next column and use Clay's formula but substitute helmet with suit?
Regards.
John

 

[blacktour]

I could but does anyone know how to make it all in one cell/column?

 

[blacktour]

Can anyone give me a hand with this still haven't figured it out?

Thanks,
Mike

 

[blacktour]

I have been trying this all day and this is as far as I've got:

IF(ISERROR(SEARCH("helmet",B7)),IF(SEARCH("suit",B7),"suit"),"Helmet")

I can't get visor to work though?

 

[erik.van.geit]

Hi,

give this a try

  A                              B     C      
1                                found list   
2 this is a Helmet from John     TRUE  Helmet 
3 no Helmets or suits available  TRUE  Suit   
4 please tell me what            FALSE other  
5 next cell has other word in it TRUE         

TEST
[Table-It] version 06 by Erik Van Geit

RANGE FORMULA (1st cell)
B2:B5 {=NOT(ISNA(MATCH(9.99999999999999E+307,SEARCH($C$2:$C$4,A2))))}

{=formula}:
select first cell
enter formula without {}
confirm with Control-Shift-Enter
then copy down

[Table-It] version 06 by Erik Van Geit

kind regards,
Erik