title: Lookup a value in the same row and return value from a column next to the matching column
body: <p>I have a spreadsheet laid out as follows, with two formulas:</p>
  
  <pre><code>      A     B     C         D
    +-------+---+-------+-----------+
  1 | 164F  | 1 | 164F  | formula 1 |
    +-------+---+-------+-----------+
  2 | 1638  | 4 | 1638  | formula 2 |
    +-------+---+-------+-----------+
  </code></pre>
  
  <p>I want the formula 1 to look at the value in the column C and return the value from the right column referent to the value seen, like if the value of column C is 164F, it will search the row for the left and return the value in column B =1, value which is at the right of the value looked. I'm working on a table for referencing. I have provided an example <a href="http://www.excelforum.com/newthread.php?do=postthread&amp;f=8" rel="nofollow">on this Excel forum</a>.</p>