清除第二个依赖下拉Excel-Clear2ndDependentDropDownExcel

0  

In the second drop down, you can use formulas. If your fruit choices are in one column, and the vegetable choices are in another, you can do something like the following...

在第二个下拉列表中,您可以使用公式。如果您的水果选择在一列中,而蔬菜选择在另一列中,您可以执行以下操作...

Assuming that your Drop Down 1 is in A10, your list of Fruits is C1:C10, list of Vegetables is D1:D10:

假设您的Drop Down 1在A10中,您的水果列表是C1:C10,蔬菜列表是D1:D10:

For the second drop down in cell A20, go to Data Validation -> List. Instead of just choosing your list of either Fruits, or Vegetables, do this "=If(A10="Fruit",c1:c10,d1:d10)".

对于单元格A20中的第二个下拉列表,请转到数据验证 - >列表。不要只选择水果或蔬菜的列表,而是“= If(A10 =”Fruit“,c1:c10,d1:d10)”。

Then, as you change the A1 value from Fruits to Vegetables, your second drop down will update the list choices.

然后,当您将A1值从Fruits更改为Vegetables时,第二个下拉菜单将更新列表选项。

Edit: I don't know if you are going to be adding to those lists of fruits/vegetables, but you can also used named ranges. If you name all of your Fruit choices as, say, "Fruit", and vegetables as "Vegetables", the data validation can use these named ranges: "=If(A10="Fruit",Fruits,Vegetables)".

编辑:我不知道你是否要添加水果/蔬菜列表,但你也可以使用命名范围。如果您将所有Fruit选项命名为“Fruit”,将蔬菜命名为“Vegetables”,则数据验证可以使用这些命名范围:“= If(A10 =”Fruit“,Fruits,Vegetables)”。

0  

I realized I was doing this all the hard way. Instead of doing a second drop down, I removed it and I decided to do HLOOKUP. Then I could find the word in question.

我意识到我正在努力做到这一点。我没有做第二次下拉,而是删除了它,我决定做HLOOKUP。然后我可以找到有问题的单词。

Many thanks to all those that have answered.

非常感谢所有回答的人。