title: Iterate through an Excel dropdown/validation list
body: <p>I have a cell with a validation list that changes depending on other settings.  Is it possible to iterate through that cell in code?
  Is it also possible to set that cell to the nth item in the list?</p>
  
  <p>Example:
  <img src="https://i.stack.imgur.com/lULgG.jpg" alt="enter image description here">
  The drop down for E2 depends on what was selected for D2.  I would like to be able to iterate through whatever list is in E2 without having to check D2.</p>
  
  <p>Thank you.</p>