title: How to lookup and sum with Google Sheets
body: <p>So I have this spreadsheet</p>
  <p><a href="https://i.stack.imgur.com/M7u2x.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/M7u2x.png" alt="enter image description here" /></a></p>
  <p>And I want to essentially grab the value to the right of the value.</p>
  <p>So for example, if I look for <code>x</code>, I want to get the values of <code>E9</code>, and <code>E15</code>. So far this is my query:</p>
  <pre><code>=LOOKUP(D23 , $D$5:$E$16 , $E$5:$E$16 , FALSE)
  </code></pre>
  <p>But all I'm getting is:</p>
  <pre><code>Error
  Formula parse error
  </code></pre>
  <p>Any idea what I'm doing wrong?</p>
  <p>EDIT:</p>
  <p>I thought I might be making a mistake, since I forgot I'd have to <code>SUM</code>, but after changing the key to <code>tax</code> it still doesn't work</p>
  <p>I tried both <code>LOOKUP</code> and <code>VLOOKUP</code>, same problem in each</p>
  <p>I also tried smth I found in a tutorial, but no luck</p>
  <pre><code>=VLOOKUP(D23 , $D$5:$E$16 , 2 , FALSE)
  </code></pre>
  <p>TO FUTURE SEARCHERS:</p>
  <p>To figure out which &quot;breaker&quot; you need (<code>,</code> of <code>;</code>), take a close look at the formula help. It's the blue question mark next to the <code>fx</code></p>