title: Search up CSV values in cell in table via vlookup and apply values
body: <p>Let's say I have the following table: </p>
  
  <p><a href="https://i.imgur.com/qa2kiFv.png" rel="nofollow noreferrer">https://i.imgur.com/qa2kiFv.png</a></p>
  
  <p>In a different table, I have a column with comma-separated values of the deduction numbers that apply: (E.g. 1, 4, 6).</p>
  
  <p>How can I vlookup all of the corresponding deduction number point values and sum them up?</p>
  
  <p>For instance, if the cell said 7, 1 , and 2a, it would sum up -15, -5, and -2 for a total of -22.</p>
  
  <p>Examples: <a href="https://i.imgur.com/CjhNkZU.png" rel="nofollow noreferrer">https://i.imgur.com/CjhNkZU.png</a></p>
  
  <p>(Note: I do not have enough reputation to post images, so if anyone would be as benevolent as to edit the post and add the images, I'd appreciate it.)</p>