title: Excel dependent dynamic lists based on Teacher Name
body: <p>So I have a sheet with 2 tables (being retrieved from a SQL Query): Teachers and TeacherSets.</p>
  
  <p>Teachers Table (single column):</p>
  
  <pre><code>(Header) Teachers 
           Teacher1
           Teacher2
           Teacher3
  </code></pre>
  
  <p>TeacherSets Table (2 columns):</p>
  
  <pre><code>Header    Teacher    Set
            Teacher1   ABC
            Teacher2   XYZ
            Teacher1   GHI
            Teacher2   AAA  
  </code></pre>
  
  <p>I am already using Teachers to retrieve a dropdown list but what I'd like to do is create another list that once I've selected the teacher from the first drop down, it only allows me to select only the matching sets for that teacher from table TeacherSets.</p>
  
  <p>Selecting Teacher1 would only allow me to see ABC and GHI in the corresponding dropdown list.</p>
  
  <p>I've had a read around and most of the solutions refer to selection based on lookups to multiple columns with defined names but this is slightly different or is it not?</p>
  
  <p>Thanks,</p>