title: Incorrect results with Excel's LOOKUP or VLOOKUP looking up text
body: <p>Say I have 9 reference cells in one column which each have a corresponding value in the next column as seen below:</p>
  
  <pre><code>Alpha   1
  Beta    2
  Gamma   3
  Delta   4
  Epsilon 5
  Zeta    6
  Eta     7
  Theta   8
  Iota    9
  </code></pre>
  
  <p>I would like to use VLOOKUP or LOOKUP to enter the reference cell, and return the corresponding value.
  For example if 'Alpha' was typed in cell A1, and the above two columns were in B and C I would use =LOOKUP(A1, $B$1:$B$9, $C$1:$C$9).  Which should return 1.  However, if I do this for all nine cells, I get the following results instead:</p>
  
  <pre><code>1
  2
  7
  2
  5
  9
  7
  8
  7
  </code></pre>
  
  <p>I get the same results whether I am using =LOOKUP with two separate vectors or one array, or if I use =VLOOKUP.</p>
  
  <p>Any insight on why this is happening would be appreciated.</p>