title: How to merge/copy a single column's values in one sheet into another sheet based on the values of a column using excel?
body: <p>I have two excel spreadsheets (that I can put onto two separate sheets within one sheet, one call A, and one called B).</p>
  
  <p>Spreadsheet A/Or Sheet A</p>
  
  <pre><code>NAME,SPORT
  Jordan,Tennis
  Jordan,Basketball
  Jess,Tennis
  Mike,Baseball
  </code></pre>
  
  <p>Spreadsheet B/Or Sheet B</p>
  
  <pre><code>NAME,AGE
  Jorden,5
  Jess, 6
  Mike, 10
  </code></pre>
  
  <p>I want to make it so that I can merge the two spreadsheets such that the "Age" column is added to Sheet A with the resulting spreadsheet:</p>
  
  <pre><code>NAME,SPORT,AGE
  Jordan,Tennis,5
  Jordan,Basketball,5
  Jess,Tennis,6
  Mike,Baseball,10
  </code></pre>
  
  <p>How can I do this?</p>
  
  <p>Assume there is an exact match for names in Spreadsheet B to Spreadsheet A (first names only, no need to worry about last names).</p>
  
  <p>Range of values could be variable, but if it's just a matter of making sure the range is updated as new values are put in manually, it's okay. Unless there is a smarter way.</p>