Multi-column Drop Down List without Transposing Data

[renjie0315]

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 · Accepted solution]

@renjie0315 

See Excel Dependent Drop Down Lists from Sorted Table with OFFSET 

[#3]

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)