return yes or no

[Patcheen]

im trying to get yes or no if a certain cell contains the words own goal ?

heres my prob in E608 ih have the words Own Goal James Russell

this is what is use to use =IF(E608="Own goal","Yes","No") this would return yes if only it contained Own goal

but now that ive added the own goal scorer to it which is now

own goal - James Russell

so now how can i return an Yes if E608 conatins own goal and ignore james russell?

i tried this =IF(E608="*Own goal*","Yes","No") but it returns No

 

[Fluff]

How about
=IF(ISERROR(FIND("own goal",E608)),"no","yes")

 

[Scott T]

try

=IF(LEFT(E608,8)="own goal","Yes","No")

 

[AhoyNC]

Try
=IF(ISNUMBER(SEARCH("Own goal",E608)),"yes","no")

 

[Patcheen]

it returns an - No

 

[Patcheen]

Thank you Scott T it worked and thank you to all of you for your help also

 

[Scott T]

it returns an - No

Which formula?

Note that FIND is case sensitive. Search that AHOYNC used is not case sensitive.
also note my formula assumes own goal will always be at the start of the string.




You're welcome.

 

[Fluff]

@Scott T
Probably mine