title: Is there an Excel function that sums multiple values each multiplied by a different lookup value?
body: <p>I am setting up an Excel workbook that will take material usages as inputs. I want to be able to multiply these inputs against known material compositions that I have entered in a table. </p>
  
  <p>Currently I have been doing =usage material1*vlookup(material1,material table,index,false)+usage material2*vlookup(material2,material table,index,false).....</p>
  
  <p><a href="https://i.stack.imgur.com/s8zqH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/s8zqH.png" alt="enter image description here"></a></p>
  
  <p>Is there an easier way to do this considering I have large sets of material usages? I really want to avoid having the same formula repeated up to 30 times in the same cell just to sum it all up. </p>
  
  <p>I would like a formula that will automatically multiply material usage * looked up composition and sum this formula for all materials input.</p>