title: Match name and copy row from sheet 1 to sheet 2 on corresponding column
body: <p>I asked a very similar question to this one <a href="https://stackoverflow.com/questions/17371401/compare-a-cell-to-a-list-and-if-match-mark-a-different-column-in-excel">here</a>, but I am trying to identify if a cell's numerical value is contained in a list of cells on a different sheet. If the cell from sheet A matches a cell in sheet B, mark a different column in B with a corresponding row in sheet A, otherwise leave it blank. An example is below:</p>
  
  <pre><code>Sheet A
  
  Column A | Column B
  -------------------
     1        John
     2        Sue
     4        Bob
  </code></pre>
  
  <p>I would like the corresponding Sheet B to populate Column B like this:</p>
  
  <pre><code>Sheet B
  
  Column A | Column B
  -------------------
     2         Sue
     3        
     4         Bob
  </code></pre>
  
  <hr>
  
  <pre><code>=IF(ISNUMBER(MATCH(I2, 'SALT, WOD, Champion Members'!A:A, 0)), "Y", "N")
  </code></pre>
  
  <p>I have been using the above answer to populate a different column in the same workbook, and I'm thinking I can maybe use this formula, but instead of "Y" or "N", somehow preserve the row.</p>