Multi-column Drop Down List without Transposing Data

Copper Contributor

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. Is there any method to do so without transposing the data?




2 Replies
best response confirmed by renjie0315 (Copper Contributor)
Thanks 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)
1 best response

Accepted Solutions