title: Excel Macro (VBA) that checks cell values against a list in another workbook
body: <p>I have two workbooks, one that is data (We'll call WB 1) that needs the values in column k checked against values on another workbook (We'll call WB 2) that contains the true values for the entries. Each entry has a quantity attached to it so the price varies dependent on that. WB 1 is in a list with entries on each row and WB 2 has an item on each row and each column is the price for that quantity. I need a macro that will check these values against each other and replace any values on WB 1 with the correct value from WB 2.</p>
  
  <p>Example Data:</p>
  
  <pre><code>WB 1
      | Column A  | Column C | Column K |
       ---------------------------------
      | Item Name |    30    |  $5.42   |
  
  WB 2
      | Column A  | Column F | Column G | Column H | ... |
                       15         30         45
       --------------------------------------------------
      | Item Name |  $2.86   |   $4.53  |  $6.00   | ... |
  </code></pre>