# Certain words in cells

#### blacktour

##### Board Regular
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)

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Try

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

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

Code:
``=IF(SEARCH("Helmet",A6),"Helmet",IF(SEARCH("Suit",A6),"Suit","Other"))``

That does not work?

Thanks.

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

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

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

Thanks,
Mike

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

Code:
``IF(ISERROR(SEARCH("helmet",B7)),IF(SEARCH("suit",B7),"suit"),"Helmet")``

I can't get visor to work though?

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
Code:
``````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

Replies
3
Views
182
Replies
7
Views
202
Replies
2
Views
363
Replies
8
Views
306
Replies
0
Views
152

1,221,497
Messages
6,160,154
Members
451,625
Latest member
sukhman

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back