Clear 2nd Dependent Drop Down Excel -

i figured out how make dependent drop down. finally.

my problem when change first drop down, second 1 still has options first option.

drop down 1:

fruit
vegetables

fruits drop down info: apples
bananas

vegetables drop down info: carrots
cucumbers

if choose fruit, can choose apples. however, if choose vegetables, apples still option until change it.

is there solution purge second drop down every time change made on first one?

i found: dependent drop down list in excel auto update i'm confused on how make work situation. drop down in a10 , secondary a20. next plan learn vba.

in second drop down, can use formulas. if fruit choices in 1 column, , vegetable choices in another, can following...

assuming drop down 1 in a10, list of fruits c1:c10, list of vegetables d1:d10:

for second drop down in cell a20, go data validation -> list. instead of choosing list of either fruits, or vegetables, "=if(a10="fruit",c1:c10,d1:d10)".

then, change a1 value fruits vegetables, second drop down update list choices.

edit: don't know if going adding lists of fruits/vegetables, can used named ranges. if name of fruit choices as, say, "fruit", , vegetables "vegetables", data validation can use these named ranges: "=if(a10="fruit",fruits,vegetables)".