title: How to do a lookup in excel with VBA then change the cell contents?
body: <p>I have been using <code>VLOOKUP</code> to find a specific value that corresponds to a property of a unique <code>ID</code> ie. using it to lookup the cost of a unique item ID:</p>
  
  <pre><code>ID  Cost
  ----------
  A   $12    
  B   $16
  </code></pre>
  
  <p>How can I do a ID lookup and then modify the contents of the cell instead of just reading what corresponds to it?</p>