title: Formula to get cell values of specific column and a variable row number
body: <p>I need a formula to retrieve a value defined by a specific column (always B) and a variable row number (A).</p>
  
  <p>What is the formula I need to write in column C to retrieve the right names as shown below?</p>
  
  <pre><code> _A_____B_______C_____
    3 | Lucas |  Gary      &lt;--B3
   _____________________
    1 | Mark  |  Lucas     &lt;--B1
   _____________________
    2 | Gary  |  Mark      &lt;--B2
  </code></pre>