Forum Discussion

Copper Contributor

Jan 31, 2023

Solved

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

excel

HansVogelaar
Jan 31, 2023
renjie0315

See Excel Dependent Drop Down Lists from Sorted Table with OFFSET

2 Replies

HansVogelaar
MVP
Jan 31, 2023
renjie0315

See Excel Dependent Drop Down Lists from Sorted Table with OFFSET
- renjie0315
  Copper Contributor
  Feb 01, 2023
  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)