title: How to import data from one sheet to another
body: <p>I have two different work sheets in excel with the same headings in in all the row 1 cells(a1 = id, b1 = name, c1 = price). My question is, is there a way to import data(like the name) from 1 worksheet to the other where the "id" is the same in both worksheets.</p>
  
  <pre><code>eg.
  sheet 1                             sheet2
  ID      Name       Price            ID        Name        Price
  xyz     Bag        20               abc                     15
  abc     jacket     15               xyz                     20
  </code></pre>
  
  <p>So is there a way to add the "Name" in sheet 1 the "Name" in sheet 2 where the "ID" in sheet 1 = "ID" in sheet 2?</p>
  
  <p>Without coping and pasting of course
  Thanks</p>