title: How to return a value to the left of a table array with VLOOKUP?
body: <p>I need help searching Column E for value=1 and return the value of column A for the same row. VLOOKUP isn't working because there are many columns being searched and there are several 1's in the lookup, and I couldn't seem to search just 1 column using VLOOKUP. Here's how my spreadsheet looks...</p>
  
  <pre><code>   A         B           C            D            E
  1 Name     Weight     WeightRank     Height     HeightRank     
  2 Mike       170          3           6.3           2
  3 Richard    200          1           6.0           3
  4 Charles    185          2           7.0           1
  </code></pre>
  
  <p>So I want to search column E for value=1 and return the corresponding value in column A, which in this example would search "HeightRank" for "value=1" and return "Charles"</p>
  
  <p>I tried using <code>=VLOOKUP(1,E:E,1)</code> but that returns an error.
  I tried using <code>=VLOOKUP(1,A1:E3,1)</code> but that returns an error.</p>