Certain words in cells

blacktour

Board Regular
Joined
May 24, 2005
Messages
219
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.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

blacktour

Board Regular
Joined
May 24, 2005
Messages
219
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.
 

jolivanes

Well-known Member
Joined
Sep 5, 2004
Messages
1,785
Office Version
  1. 2013
  2. 2007
Platform
  1. Windows

ADVERTISEMENT

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

blacktour

Board Regular
Joined
May 24, 2005
Messages
219

ADVERTISEMENT

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

Thanks,
Mike
 

blacktour

Board Regular
Joined
May 24, 2005
Messages
219
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?
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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
 

Forum statistics

Threads
1,136,616
Messages
5,676,838
Members
419,653
Latest member
analyticalchemist94

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top