My dependent dro

[BittenApple]

Hello all

I enter this formula for my dropdowns, for third dropdown that refer the second dropdown
=Indirect(substitute($F$4, " ", "_"))

The third dropdown works perfect but it freezes on one of the entries from second dropdown menu. I don't know how to fix it.

Any tips?

The third dropdown doesn't work for those entries which contain parentheses or dashes?





Regards,

[BittenApple]

Hello all

I enter this formula for my dropdowns, for third dropdown that refer the second dropdown
=Indirect(substitute($F$4, " ", "_"))

The third dropdown works perfect but it freezes on one of the entries from second dropdown menu. I don't know how to fix it.

The third Dropdown Doesn't work for those entries which contain parenthesis or dash.

Any tips?





Regards,

[BittenApple]

Hello team,
I resolved it by entering several substitute, which substitutes "-", "(", ")", " ".
Thanks!