I'm having trouble coming up with a solid solution for the attached. I know how to use data validation and range references to create dependent drop-down lists from small amounts of source data, however, the my source data is multi-layered and requires a lot of extra table and range name creation via the method I know how to use.
Can you view the two tabs in the attached and offer a solution? One tab has the source data (LIST) and the 2nd tab is where the drop downs need to live. I have tried variations of OFFSET with COUNTIF with wonky results.
As always, thanks for your help!