title: How to copy rows if column contains specific text/value in Excel?
body: <p>I have two files,say F1 and F2.</p>
  
  <p>If data in column1 from F1 matches Column1 from F2, paste column2 from F1 to F2.</p>
  
  <p>Eg.</p>
  
  <pre><code> file F1 has
      column1  column2
      X        value1
      Y        value2
      Z        value3
  
  
  
  file F2 has
      column1    column2
      Y          key1
      Z          key2
      X          key3
  </code></pre>
  
  <p>I am trying to insert a new column in F2 to look like:</p>
  
  <pre><code>column1   column2  column3
  X         value1   key3
  Y         value2   key1
  Z         value3   key2
  </code></pre>
  
  <p>This is <a href="http://www.extendoffice.com/documents/excel/2505-excel-if-column-contains-text-value-then-copy-row.html#filter" rel="nofollow">achievable</a> within same file. How can accomplish this across multiple files in excel/libreoffice?</p>