Initial default drop downs and dependent default drop downs

Originally Posted by hudsone777

Hi AliGW,

Unfortunately, this did not work for me. I got banana for A3-A6 and that is all. Assuming the A3 was a typo, I tried putting them in B3-B6 and got banana for all with no drop down lists.

That's why I told you to turn auto-calculation on. It is currently set to manual. As soon as you set it to on, you will get the right results.