title: Conditional drop-down list from single table
body: <p>It is fairly simple to populate a drop-down list from a fixed table of names (here 'Name1') using data validation.</p>
  
  <p><img src="https://i.stack.imgur.com/1RvTA.png" alt="enter image description here"></p>
  
  <p>Is it possible to populate a second drop-down list from a second, unnormalised table, akin to doing a lookup on the range with the input value being the selection from the first drop-down list?</p>
  
  <p><img src="https://i.stack.imgur.com/Ue8EG.png" alt="enter image description here"></p>
  
  <p>e.g. Selecting 'A' from the first drop-down means only 'D', 'E' and 'F' are available in the second drop-down.</p>
  
  <p>Unfortunately, the second table cannot be split out into tables 'A', 'B' and 'C' as there are plenty of tutorials explaining how to do it that way.</p>