title: LibreOffice formula - find from list and sum the quantity
body: <p>I have a spredsheet that holds in first colum Part Number and in the second price in $ for this PN( and some other details). The list is aprox 100.000 items long. </p>
  
  <p>Sometimes I get a from the customer a query about the total price for eg. 500 item, some of them in different quantity. </p>
  
  <p>If possible could I create a second sheet in that sheet import the requested PN and their quanitiy and than with a formula get the data from the first sheet1 the total amount. </p>
  
  <p>For eg.</p>
  
  <pre><code>    Sheet 1 
  PN  Price
  A   234
  B   765
  C   547
  D   24
  E   45
  F   754
  
      Sheet 2     
  Pn  Quantity    Total
  A   1           234
  D   3           72
  E   2           90
                  396
  </code></pre>
  
  <p>Thanks in advance </p>