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...