title: Change Text if Matches?
body: <p>Right now I have this copying data from Worksheet 1 Column B. </p>
  
  <p>I want it so that it doesn't copy it it just puts Completed if it says Completed or Not Completed if it says Not Completed. Right now it copies the extra info I have next to Completed.</p>
  
  <pre><code>With Sheets("Worksheet 2")
      .Range("B1").Formula = "=IF(ISERROR(VLOOKUP(A1,'WorkSheet 1'!A:B,2,0))," &amp; """""" &amp; ",VLOOKUP(A1,'Worksheet 1'!A:B,2,0))"
      .Range("B1").Copy Range("B2:B" &amp; Range("A" &amp; Rows.Count).End(xlUp).Row)
  End With
  </code></pre>