Step 2: Create and name controls to realize the first-level menu;
The number in cell A2 indicates the position of A 1 in the drop-down list.
Step 3: Customize the name as needed, set the control format, and realize the secondary menu;
The number in cell B2 indicates the position of B 1 in the drop-down list.
User-defined name: group =OFFSET(Sheet 1! $B$2, match (offset (Sheet 1! $A$2,Sheet 1! $A$2,)Sheet 1! $C$3:$C$99,),,COUNTIF(Sheet 1! $C$3:$C$99, offset printing (Sheet 1! $A$2,Sheet 1! $A$2,),)
Q: How to implement a two-level drop-down menu with form controls?
A: There are three steps:
Step 1: Load the control: click the office button in the upper left corner-》excel Options-Common-to display the development tool tab in the ribbon; Click Development Tools-Insert-Form Control-Combo Box;
Step 2: Create and name controls to realize the first-level menu;
The number in cell A2 indicates the position of A 1 in the drop-down list.
Step 3: Customize the name as needed, set the control format, and realize the secondary menu;
The number in cell B2 indicates the position of B 1 in the drop-down list.
User-defined name: group =OFFSET(Sheet 1! $B$2, match (offset (Sheet 1! $A$2,Sheet 1! $A$2,)Sheet 1! $C$3:$C$99,),,COUNTIF(Sheet 1! $C$3:$C$99, offset printing (Sheet 1! $A$2,Sheet 1! $A$2,),)
Note: The drop-down button implemented by this method is always displayed, which is different from the data validity.