It is fairly simple to populate a drop-down list from a fixed table of names (here 'Name1') using data validation.
使用数据验证从固定的名称表(此处为“Name1”)填充下拉列表非常简单。
Is it possible to populate a second drop-down list from a second, unnormalised table, akin to doing a lookup on the range with the input value being the selection from the first drop-down list?
是否可以从第二个非标准化表中填充第二个下拉列表,类似于对范围进行查找,输入值是从第一个下拉列表中选择的?
e.g. Selecting 'A' from the first drop-down means only 'D', 'E' and 'F' are available in the second drop-down.
例如从第一个下拉列表中选择“A”表示在第二个下拉列表中只有“D”,“E”和“F”可用。
Unfortunately, the second table cannot be split out into tables 'A', 'B' and 'C' as there are plenty of tutorials explaining how to do it that way.
不幸的是,第二个表不能拆分成表'A','B'和'C',因为有很多教程解释如何以这种方式执行。
1 个解决方案
#1
0
Take a look at the following link, it describes a complex drop down pretty well and includes a nice little video tutorial http://www.contextures.com/xlDataVal02.html
看看以下链接,它描述了一个复杂的下拉,并包括一个很好的小视频教程http://www.contextures.com/xlDataVal02.html
#1
0
Take a look at the following link, it describes a complex drop down pretty well and includes a nice little video tutorial http://www.contextures.com/xlDataVal02.html
看看以下链接,它描述了一个复杂的下拉,并包括一个很好的小视频教程http://www.contextures.com/xlDataVal02.html