title: How to make a conditional dropdown base on cell values using VBA in Excel
body: <p>I am trying to make a dropdown in Excel 2016, but as don't use it often, I don't now how to do it.</p>
  
  <p>The data looks like this :</p>
  
  <p><img src="https://i.stack.imgur.com/XGv8m.png" alt="Excel data screenshot"></p>
  
  <p>I am trying to create a dropdown which will contains the values of "Title 1", "Title2", "Title3" based on column E cell value. </p>
  
  <p>In other word, something like this :</p>
  
  <pre><code>if Cell E == 'index'
    add Cell A value to dropdown
  end
  </code></pre>
  
  <p>What would be the best way to accomplish this? Can I do it using excel functions or do I need VBA? And if VBA is needed, any hint would be greatly appreciated.</p>