Hi all,
<tbody>
</tbody>
I am trying to create dependant dropdown lists so that based on Manufacturing line, Type1 and Type2 are possible to be selected.
So if I select PPA New product, the only choice to choose is PPA.
If I select ELH, I can choose either ELH Basic or ELH Advanced.
I know that to create dependant dropdowns, I must use =INDIRECT( ) but I don't know how to name the Type1 range. Type2 table is named as ELH so when choosing ELH as manufacturing line, the options to ELH Basic and ELH Advanced appear but how to do it the other way around in case of Type1? I tried to name it as PPA* but it it is not possible.
| Manufacturing line | Type1 | Type2 |
| PPA New product | PPA | ELH Basic |
| PPA Old product | ELH Advanced | |
| ELH |
<tbody>
</tbody>
I am trying to create dependant dropdown lists so that based on Manufacturing line, Type1 and Type2 are possible to be selected.
So if I select PPA New product, the only choice to choose is PPA.
If I select ELH, I can choose either ELH Basic or ELH Advanced.
I know that to create dependant dropdowns, I must use =INDIRECT( ) but I don't know how to name the Type1 range. Type2 table is named as ELH so when choosing ELH as manufacturing line, the options to ELH Basic and ELH Advanced appear but how to do it the other way around in case of Type1? I tried to name it as PPA* but it it is not possible.
