title: Dynamically set cell values from table in Excel
body: <p>I've got an excel document that essentially looks like this (imagine it having around 15 000 rows):</p>
  
  <pre><code>A    B    C    D    E    F
  ---------------------------
  Art  Price    Art  Price
  ---------------------------
  A    1         A    5
  A    3         B    10
  A    4         C    8
  B    7         
  B    2
  C    3
  C    15
  </code></pre>
  
  <p>As you can see the prices in column B are inconsistent. </p>
  
  <p>What I want to do is to set the prices (in column B) to the correct prices (that are found in column E) based on the articles name (found in column A and D).</p>
  
  <p>Unfortunately I'm at loss when it comes to VBA in Excel, and formulas in Excel, what would be a smart way to approach (or solve) this?</p>
  
  <p>Thank you in advance!</p>