Dependent dropdowns Excel

New Contributor

Best,
Is it possible to connect 3 dropdowns with each other. Independence.

Eg.
Field 1 has as dropdown values = Cat1 / Cat2 / Cat3
Field 2 : of which the value depends on what chosen in field 1 (Step1.CAT1 / Step2.CAT1 / Step3/CAT3)
Field 3: the value of this field depends on what is selected in field 1 and field 2

I get this done with dget but disadvantage of this is that I cannot copy it to multiple lines.

Thanks in advance.

 

4 Replies

@Segeyuti 

See the attached workbook for a small example

Thanks a lot !
Would it also be possible that the third field is filled in automatically based on the value in field2
Thanks

@Segeyuti 

Here is an example, I don't know if it fits ... to be honest I haven't read everything

... well maybe that helps too :)).

 

Thank you for your understanding and patience

 

Wish you a nice day.

 

Nikolino

I know I don't know anything (Socrates)

@Segeyuti 

So in fact, you want two drop downs plus one value depending on those.

Here is a modified example.