Forum Discussion
soultaker
Dec 04, 2020Copper Contributor
Need help with dynamic dependent drop down list...
Hey Guys! I'm trying to make a excel sheet that has one array of options depending on another array... I want to creat two drop down list. List 1 is choosing from A&B, then depend on th...
mathetes
Dec 04, 2020Gold Contributor
Here's an example I built a couple of months ago that displays different secondary drop downs depending upon a first choice. See if it points you in the right direction. It does make use of Dynamic Array functions and requires the most recent version of Excel.