title: If two cells match, return value from third
body: <p>Here's a simple explanation of what I'm having trouble with.</p>
  
  <p>Column A: List of 2300 order numbers<br>
  Column B: Email Address associated with an order number<br>
  Column C: List of 100 specific order numbers that I need the email address for  </p>
  
  <p>So, I'm looking to search column A for a value that matches C, and return the email address from column B in a new column (D).  </p>
  
  <p>The current formula almost works, but instead of returning the email address where A matched C, it returns the email address from the same row.</p>
  
  <pre><code>=IF(ISERROR(MATCH(C2,A:A,0)),B2)    
  </code></pre>
  
  <p>Essentially I just need B2 in the formula above to return the value from the same line that matched.</p>