验证在条件下下拉 [英] Validation Drop down on a condition

问题描述

有点令人困惑的写我的想法，但不好尝试。
这是我能做的。我的垂直单元格中有一个下拉列表，所以我有一个名单可以从[name] - > [define]和[data] - > [validation]链接。
我想要的是另一个垂直单元格根据第一个条件填充另一个下拉列表。

its a bit confusing to write my idea but ill give it a try. Here is what i was able to do. I have a drop down on my vertical cells, so i have a list of names to pick from which is linked by [name]-> [define] and [data] -> [validation]. what i would like is another vertical cell to populate another drop down depending on the condition of the first.

例如我有一个水果和蔬菜的列表。我的第一个下拉菜单询问类型，所以我选择水果。因为这样的选择，我的第二个下拉菜单只会给我一个水果列表（没有蔬菜），反之亦然。+

for instance i have a list of fruits and vegetables. My first drop down menu asks the type so i select fruit. Because of such selection my second drop down will give me a list of fruits only (no vegetables) and vice versa.+

你的帮助非常感谢。

感谢帮派！

如果我想命名单元格而不是蔬菜但2009年和2010年水果我收到错误。有没有办法？
谢谢

if i want to name the cell instead of vegetable but 2009 and fruit 2010 i get an error. is there a way arround? thanks

推荐答案

我们可以使用一些命名范围。

Let's work with some named ranges.

名称E7选项

将E4和水果中的蔬菜放入E5;

Put "vegetables" into E4 and "fruits" into E5;

在E7中，数据>验证>列表，来源$ E $ 4：$ E $ 5;

in E7, Data > Validation > List, source $E$4:$E$5;

将一些蔬菜放入H4：H7;名称范围蔬菜;

put some vegetables into H4:H7; name that range "vegetables";

把一些水果放入J4：J7;名称范围水果;

put some fruits into J4:J7; name that range "fruits";

现在，在E8：数据>验证>列表中，源= INDIRECT（选项）。

Now, in E8: Data > Validation > List, source "=INDIRECT(option)".

当您在E7中进行选择时，E8的选项将相应设置。

When you make a choice in E7, the options for E8 are set accordingly.

这篇关于验证在条件下下拉的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！