title: Copy duplicate rows in Excel based on a column condition
body: <p>When adding a new row in a worksheet in Excel I'm looking to ensure that if columns D and E exist together in column D and E of another existing row, column F from that existing row is copied into column F in the new row. </p>
  
  <pre><code>  A    B    C    D    E    F
    A    B    C    D    E    F
    A    B    C    D    E    F
   NEW  NEW  NEW  NEW  NEW  NEW
  </code></pre>
  
  <p>Can this be done using the IF function or is it easier to produce in VBA?</p>