title: Excel formula for: If match then paste
body: <p>I'm looking for a formula on excel to do the following.</p>
  
  <p>If a value on a spreadsheet is a match to a value on another spreadsheet:</p>
  
  <p>Then paste the cell next to the match from the first spreadsheet
  into the cell next to the match on the other spreadsheet.</p>
  
  <p>This is for a stock spreadsheet from my supplier, it is 2 columns, 1 with an item code and the 2nd with a quantity in stock.</p>
  
  <p>I need to check if the code exists on my other spreadsheet and if so paste the stock quantity from the shop spreadsheet in the cell next to the match on my spreadsheet.</p>