...5个单元格5个选项数字(下拉菜单会做,单怎么组合起来) 8、8、2...答:C列输入选项数字,A1设置下拉菜单,序列为C1:C5 D1=INDEX(C$1:C$5,SMALL(IF(ROW(C$1:C$5)<>MATCH($A$1,C$1:C$5,0),ROW(C$1:C$5),1000),ROW(A1)))E1=INDEX(D$1:D$4,SMALL(IF(ROW(D$1:D$4)<>MATCH($A$2,D$1:D$4,0),ROW(D$1:D$4),1000),ROW(B1)))F1=...