title: If Statement Excel Wildcard
body: <p>I have two columns, Ref and Text. I need formula to know if text column has <em>dispute</em> word in it. All the same reference should show "Yes" in dispute column.
  e.g. in below case first 4 cells in dispute column should show "Yes"     </p>
  
  <pre><code>Reference   Text                    Dispute
  5558012265  Dispute 5004710 06/01   
  5558012265                          
  5558012265  Dispute 5004710 06/01   
  5558012265                          
  5551007340      
  5551007340      
  </code></pre>
  
  <p>Please help I will be very thankful to you</p>