title: Can I pull correct values for a variable from an old spreadsheet into a new one that's missing those values?
body: <p>I have an excel spreadsheet with several columns, each representing different variables collected from various patients (rows). One of the columns is the unique medical record #, another is a unique visit identification #. The problematic one is "age." I must have inadvertently dragged and replaced the ages of about half of my subjects, since I doubt that >3000 of my 6000 patients are 54 years old.</p>
  
  <p>I have the original file with correct ID# and age pairs, but I've done considerable work on this file and cannot start over. Is there a way in my new file to look at the ID# in column C, go to the old excel file, find that ID#, go over 3 cells to column F (age), copy that age value, go back to the new excel file and paste the correct age for each ID#?</p>
  
  <p>I cannot simply sort both files by ID# and copy/paste all of the ages as a number of the cases have been intentionally removed and so the ID#s wouldn't match up because the total N is different.</p>
  
  <p>I also have SPSS and R available to me, although I'm not particularly proficient with either.</p>
  
  <p>Just, as an example, here's what the two spreadsheets look like:</p>
  
  <p><a href="http://imgur.com/OjZsLEJ" rel="nofollow">http://imgur.com/OjZsLEJ</a></p>
  
  <p>I've manually highlighted the bad values, but in reality there are 3000+ of them and manually checking would be very time consuming.</p>
  
  <p>Thanks in advance!</p>