finding certain characters within a string within multiple cells

Hi Folks, I am hoping someone can put me straight on this one. In the cells
listed within the array below I want to look to see if the word forfeit
appears anywhere in the cell. For looking at one cell this formula works
fine
=IF(MID(AJ11,FIND("for",AJ11,1),7)="forfeit","Yes" ,"No")

but to try and do it an a larger scale, hmmmm doesn't want to play. Here is
what I was trying. If anyone wants to take a crack at it, it would be much
appreciated.

=IF(MID("{C9,E9,G9,I9,K9,M9,O9,Q9,S9,U9,W9,Y9,AA9} ",FIND("forfeit","{C9,E9,G
9,I9,K9,M9,O9,Q9,S9,U9,W9,Y9,AA9}",1),7)="forfeit" ,"Yes","No")

Regards

Gav !!

Hi
if you want to check if this word is somethere in teh range try
=IF(COUNTIF(A1:A100,"*forfeit*")0,"Yes","No")

--
Regards
Frank Kabel
Frankfurt, Germany


Gav !! wrote:
Hi Folks, I am hoping someone can put me straight on this one. In the
cells listed within the array below I want to look to see if the word
forfeit appears anywhere in the cell. For looking at one cell this
formula works fine
=IF(MID(AJ11,FIND("for",AJ11,1),7)="forfeit","Yes" ,"No")

but to try and do it an a larger scale, hmmmm doesn't want to play.
Here is what I was trying. If anyone wants to take a crack at it, it
would be much appreciated.


=IF(MID("{C9,E9,G9,I9,K9,M9,O9,Q9,S9,U9,W9,Y9,AA9} ",FIND("forfeit","{C9
,E9,G
9,I9,K9,M9,O9,Q9,S9,U9,W9,Y9,AA9}",1),7)="forfeit" ,"Yes","No")

Regards

Gav !!