Hello.I have data. I want choosing "a", get only relevant values to choose "b" and output value "c" (if a=10mm; for b there should be options only 1.5 and 2; e.g. selected b=2; means c=8.0mm)
Файл не найден.
Question 1: How can I do that?
Question 2: Choosing from a list of values "a" with this assignment of the matrix values are repeated. How to avoid it?
Файл не найден.

Wrote

Question 1: How can I do that?
Question 2: Choosing from a list of values "a" with this assignment of the matrix values are repeated. How to avoid it?

You may need a temp data derived from first combobox selection.
And use that new data at second combobox.
Here is your both questions answered.

Regards

combobox_question.sm (8 КиБ) скачан 29 раз(а).

You can reduce data matrix like this too.

combobox_question.sm (8 КиБ) скачан 41 раз(а).

Wrote

You can reduce data matrix like this too.

Exactly what is needed. Thank you!

Wrote

You can reduce data matrix like this too.

combobox_question.sm (8 КиБ) скачан 41 раз(а).

Hello. If I need to enter data manually, for example a=11mm or b=4, how can i do this?
The choice must be both from the list and manual. Maybe it should be an item in the list that allows manual data entry.

Wrote

Hello. If I need to enter data manually, for example a=11mm or b=4, how can i do this?

Then you won't need a combobox selector.
An if/else or cases() function shall be enough.

Regards

Wrote

Wrote

Hello. If I need to enter data manually, for example a=11mm or b=4, how can i do this?

Then you won't need a combobox selector.
An if/else or cases() function shall be enough.

Regards

I didn't find cases function(( How can be implemented this through a if/else or a function cases? Unfortunately, I haven't been able to figure this out yet((