Dependent Dropdown using INDEX
Update 12/12/2021 Since writing this post in 2017 about using a method to create a dependent dropdown using INDEX, Excel now has new revolutionary dynamic array formulas that really has overtaken all the workarounds for better dropdown lists we used to do such as described in my post below. Now the new formula SORT() + …