title: Sum values using lookup for comma-separated list in one of the columns in Excel
body: <p>I have a table which has some string keys and numerical values like this-</p>
  
  <pre><code>-----------------
  | Keys | Scores |
  -----------------
  |  k1  |   10   |
  |  k2  |   15   |
  |  k3  |    8   |
  -----------------
  </code></pre>
  
  <p>Now there's another table which has comma separated keys like this-</p>
  
  <pre><code>--------------------
  | Keys     | Total |
  --------------------
  | k1,k2    |       |
  |  k3      |       |
  | k1,k2,k3 |       |
  --------------------
  </code></pre>
  
  <p>I want to fill the "Total" column by referencing the table. Is it possible  in excel with formulas or VBScript?</p>