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() + …

Dependent Dropdown using INDEX Read More »