title: Merge two spreadsheets by matching one column
body: <p>I have an inventory list of items without prices. These items have a reference number in one of the column.</p>
  
  <p><img src="https://i.stack.imgur.com/B7lQY.png" alt="Data sample"></p>
  
  <p>The prices for these items are on <em>paper</em> price lists (1 column with reference, 1 column with price).</p>
  
  <p>I want to match each items with its price.</p>
  
  <p>Right now I am doing a search for each reference, then entering the corresponding price, but it is inefficient.</p>
  
  <p>Is there a way to enter the prices manually in another spreadsheet in bulk (one column with references, one column with prices) and then applying some logic to match each duplicate reference with its price?</p>
  
  <p>Maybe there is an even better solution that I didn't think of?</p>
  
  <p>Note: I am using LibreOffice, but I could use Excel if absolutely necessary.</p>