title: How to replace all cells in a column with a number from a list on another sheet?
body: <p>I have a list of names on Sheet1.<br>
  On Sheet2 I have those same names but column next to the names I have ID's.
  Like this:</p>
  
  <pre><code>Name |ID
  -------
  John |1
  Sarah|2
  </code></pre>
  
  <p>I'm trying to pull the data from Sheet1 into Sheet3 and replace all matching names with ID's from Sheet2</p>
  
  <p>What I have so far is</p>
  
  <pre><code>=(Sheet1!A1)
  </code></pre>
  
  <p>Now I just need to figure out how I can replace with ID from Sheet2</p>
  
  <p>I have tried all kinds of formulas I found on google but none work. How to do it?</p>