title: MS Excel, multiple rows, copy data using VLOOKUP if there are multiple rows with same values
body: <p>I have an excel spreadsheet with the following data.</p>
  
  <pre><code>ID        lastname           firstname           dob
  ------------------------------------------------------
  123       Alderson           Sophie             01-01-1900
  456                          Sophie
  5573      Alderson           Sophie             
  </code></pre>
  
  <p>I am trying to achieve something with a combination of <em><a href="http://office.microsoft.com/en-in/excel-help/vlookup-HP005209335.aspx" rel="nofollow">VLOOKUP</a></em> function and some conditional statements, but going in circles.</p>
  
  <p>All the records belong to one person (Alderson-sophie) in this case. There may be 1 record or more for the same person. But all rows may or may not have the same information as shown.</p>
  
  <p>So, I need to copy any information(cells) in the other rows belonging to the same person and  to the first row (which will be considered the primary row), making sure that if there is a difference in data between the rows, the values are copied to it and the rows other than the first one are left as it is/made blank.</p>
  
  <p>Any help / pointers please..</p>
  
  <p>Advance Thanks</p>