title: Excel - Compare one column to another and display results
body: <p>In Excel 2007, I have two columns, similar data (list of names). If the name is found in both columns I'd like to change a blank column to active. How can this be done?</p>
  
  <p>Longer Description of what I'd like to do:</p>
  
  <p>Column A:A on Sheet 1 has 300 names. Column A:A on Sheet 2 has 20 names. If the names on Sheet 2 are also in Sheet 1 I'd like to fill Column A:B on Sheet 1 with the word "Active"</p>
  
  <p>How can this be done? Thanks in advance!</p>