title: How to use a key to add up a table in excel
body: <p><a href="https://i.stack.imgur.com/HzpqA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HzpqA.png" alt="What I need" /></a></p>
  <p>Okay, so I have a bit of a challenge I have a large chart that I want to build types into on a separate chart. I then want to create sums of those new types on a third chart</p>
  <p>Chart 1:
  Sum of certain types values</p>
  <p>Chart 2:
  Identifies what types each unique identifier of chart one represent</p>
  <p>Chart 3:
  Contain unique identifiers and the values that each of those identifiers have</p>
  <p>For example:</p>
  <pre><code>On chart 2 1=A and 2=A
  On Chart 3 1=3 and 2=7
  On Chart 1 A should = 10
  </code></pre>
  <p>I was trying an</p>
  <pre><code>`xlookup(A,B:B,C:C,0)`
  </code></pre>
  <p>but that just returns the first value.</p>