在没有脚本的情况下进行此操作的方法涉及帮助程序列表.步骤如下:

The way to do this without a script involves a helper list. Here are the steps:

• 为每个列表创建命名范围
• 使用ARRAYFORMULA和INDIRECT
将列链接到第一个下拉列表
• 将第二个下拉列表的数据验证设置为由ARRAYFORMULA(INDIRECT())
填充的整个列

• Create Named Ranges for Each of Your Lists
• Link a Column to the first dropdown using ARRAYFORMULA and INDIRECT
• Set data validation of the second dropdown to that entire column being populated by ARRAYFORMULA(INDIRECT())

您可以在此处查看工作示例: https://docs.google.com/spreadsheets/d/1Snn2ZpDTpb1I96ihsRHcUqvgsijiHPQNqqRD9bc-1_A/edit?usp = sharing

You can see the working example here: https://docs.google.com/spreadsheets/d/1Snn2ZpDTpb1I96ihsRHcUqvgsijiHPQNqqRD9bc-1_A/edit?usp=sharing