I received a comment asking if a dynamic dependent drop-down list in Excel could have a list where the “table headers were actually rows and not columns?” Since I’ve already detailed how this is done in the article mentioned above, I’ll keep this short. The screen shot below is what I’ll be referencing. At the end of the post I’ll give a link to the file I used.
Conditional Drop Down List (Excel)
There are two named ranges,
-
- 1)
myCategoryH
-
- that refers to the range E1:E3 and
-
- 2)
myTableH
- that refers to range F1:G3.
A defined name, myItemListH, … Read the rest