title: Check if Cell value exists in Column, and then get the value of the NEXT Cell
body: <p>After checking if a cell value exists in a column, I need to <strong>get the value of the cell next to the matching cell</strong>. For instance, I check if the value in <code>cell A1</code> exists in <code>column B</code>, and assuming it matches <code>B5</code>, then I want the value in <code>cell C5</code>.</p>
  
  <p>To solve the first half of the problem, I did this...</p>
  
  <pre><code>=IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", "Match")
  </code></pre>
  
  <p>...and it worked. Then, thanks to an <a href="https://stackoverflow.com/a/12642375/979621">earlier answer on SO</a>, I was also able to obtain the row number of the matching cell:</p>
  
  <pre><code>=IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", "Match on Row " &amp; MATCH(A1,B:B, 0))
  </code></pre>
  
  <p>So naturally, to get the value of the next cell, I tried...</p>
  
  <pre><code>=IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", C&amp;MATCH(A1,B:B, 0))
  </code></pre>
  
  <p>...and it doesn't work.</p>
  
  <p>What am I missing? How do I append the column number to the row number returned to achieve the desired result?</p>