title: Copying rows from one file to other based on a different file
body: <p>I have one Excel file that contains 2 columns: <code>Words</code> &amp; <code>Definition</code> (3000 rows). I have another Excel file which contains only <code>words</code> not definition (200 rows).</p>
  
  <p>How can I extract only those rows (Words and definition- from 3000) which are there in the 2nd Excel file (200 rows)?</p>
  
  <p>Basically i want to filter those .</p>
  
  <p>In SQL i would write </p>
  
  <pre><code>Select * from table1 where table1.words=table2.words
  </code></pre>
  
  <p>How do i implement this in excel ? 
  Please give me the procedure too...</p>