命名范围不能有空格，因此您的范围名称将必须使用下划线或对于相关范围完全省略该字符.例如"LaborL2".

Named ranges cannot have spaces, so your range names will have to use an underscore or omit that character altogether for the dependent ranges. For example "LaborL2".

定义所有这些命名范围，LaborL1，LaborL2，InfrastructureL1等.

Define all these named ranges, LaborL1, LaborL2, InfrastructureL1, etc.

然后，您可以使用Indirect函数连接$ F18和G $ 17.喜欢

Then you can use the Indirect function to concatenate $F18 and G$17. like

=INDIRECT($F18&G$17)

然后，您可以在下拉列表中看到正确的列表.

Then you can see the correct list in the dropdown.