Forum Discussion
renjie0315
Jan 31, 2023Copper Contributor
Multi-column Drop Down List without Transposing Data
Hi all, I would like to know how to create a sub-drop-down list based on the main drop-down list. What I want is when I select "a" in cell E3, there will be selection of "1, 2, 3" in cell F3....
HansVogelaar
Jan 31, 2023MVP
- renjie0315Feb 01, 2023Copper ContributorThanks a lot! It works well for me. However, do take note the -1, as it would minus 1 cell and link it to the above data.
=OFFSET(RegionStart, MATCH(B2, RegionColumn, 0) -1, 1, COUNTIF(RegionColumn,B2), 1)