title: VBA to change cell value based on drop down selection
body: <p>I'm really not fantastic with VBA and have finally come to a halt.</p>
  <p>I'm trying to automatically change 2 cell values (in the same row) based on what selection I make from a drop down.</p>
  <pre><code>Column L - Drop down consists of Won, Lost, Quote 
  
  Column H - GO% 
  
  Column I - GET% 
  </code></pre>
  <p><strong>What I'm trying to achieve -</strong></p>
  <pre><code>If &quot;Won&quot; selected, then GO and GET cells equal 100%
  
  If &quot;Lost selected, then GO and GET cells equal 0%
  </code></pre>
  <p>I can use this formula to achieve the result but I also need users to be able to manually enter data into the GO and GET cells, effectively wiping the formula <code>=IF($L5=&quot;Won&quot;,1,IF($L5=&quot;Lost&quot;,0,&quot;&quot;))</code></p>
  <p>My data starts in row 5 but I'll need this to loop as I have 500 rows of the same.</p>
  <p>Thanks so much in advance if anyone can help :)</p>
  <h3>screenshot of the spreadsheet</h3>
  <p><img src="https://i.stack.imgur.com/UrOA6.jpg" alt="screenshot of spreadsheet" /></p>