Excel Double list please help

%3CLINGO-SUB%20id%3D%22lingo-sub-2735748%22%20slang%3D%22en-US%22%3EExcel%20Double%20list%20please%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2735748%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20list%20in%20cell%20B8%20and%20depending%20on%20the%20choise%20made%20i%20want%20a%20set%20of%20choises%20in%20C8%2C%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Remco_Verduin_0-1631181659164.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309213i631EB3F3949FBD91%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Remco_Verduin_0-1631181659164.png%22%20alt%3D%22Remco_Verduin_0-1631181659164.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ENow%20i%20have%20selected%20%22schilderwerk%20buiten%22%20depending%20on%20this%20choise%20i%20want%20different%20choises%20in%20C8%3C%2FP%3E%3CP%3EFor%20exemple%3A%20a%20teacher%20grades%20his%20test%20from%200%20to%2010%20and%200%20to%205%2C%20if%20he%20decide%20to%20go%20for%200%20to%2010%20he%20wants%20al%20number%20between%200%20and%2010%2C%26nbsp%3B%20but%20only%200%20to%205%20if%20he%20decide%20to%20grade%20it%20from%200%20to%205.%3CBR%20%2F%3EI%20someone%20can%20help%20me%20out%20they%20would%20be%20a%20hero%20for%20life%2C%20i%20have%20been%20searching%20everywhere%20without%20finding%20anything.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Remco_Verduin_1-1631181955449.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309215iD3364684B08231E7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Remco_Verduin_1-1631181955449.png%22%20alt%3D%22Remco_Verduin_1-1631181955449.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWith%20Isolatie%20I%20want%20the%205%20option%20that%20stand%20after%20isolatie.%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20you%20manage%20to%20fix%20my%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERemco%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2735748%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2735953%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Double%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2735953%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1150891%22%20target%3D%22_blank%22%3E%40Remco_Verduin%3C%2FA%3E%26nbsp%3BSearch%20on-line%20for%20%22Dependent%20dropdown%22%20and%20you'll%20find%20plenty%20options%20to%20choose%20from.%20It%20depends%20on%20your%20Excel%20version%20which%20one%20to%20use.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2735972%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Double%20list%20please%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2735972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1150891%22%20target%3D%22_blank%22%3E%40Remco_Verduin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20workbook.%20I%20used%20a%20combination%20of%20data%20validation%20and%20named%20ranges.%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2Fxldataval02.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ECreate%20Dependent%20Drop%20Down%20Lists%3C%2FA%3E%20for%20background%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2735979%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Double%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2735979%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%20Thanks%20it%20is%20working%20like%20I%20wanted%20to%20now.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2735983%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Double%20list%20please%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2735983%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%20It%20works%2C%20thank%20you%20very%20much.%3CBR%20%2F%3EI%20don't%20know%20i%20you%20also%20know%20how%20this%20works%20but%20for%20the%20option%20i%20selected%20there%20is%20a%20fixed%20data%20which%20can%20be%20automaticly%20filled%20in%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I created a list in cell B8 and depending on the choise made i want a set of choises in C8,

For example:

Remco_Verduin_0-1631181659164.png

Now i have selected "schilderwerk buiten" depending on this choise i want different choises in C8

For exemple: a teacher grades his test from 0 to 10 and 0 to 5, if he decide to go for 0 to 10 he wants al number between 0 and 10,  but only 0 to 5 if he decide to grade it from 0 to 5.
I someone can help me out they would be a hero for life, i have been searching everywhere without finding anything.

Remco_Verduin_1-1631181955449.png

With Isolatie I want the 5 option that stand after isolatie.

Let me know if you manage to fix my problem.

 

Remco 

10 Replies

@Remco_Verduin Search on-line for "Dependent dropdown" and you'll find plenty options to choose from. It depends on your Excel version which one to use.

@Remco_Verduin 

See the attached workbook. I used a combination of data validation and named ranges.

See Create Dependent Drop Down Lists for background information.

@Riny_van_Eekelen Thanks it is working like I wanted to now.
@Hans Vogelaar It works, thank you very much.
I don't know i you also know how this works but for the option i selected there is a fixed data which can be automaticly filled in

@Remco_Verduin 

Would you like the first option to be filled in in column C?

 

(Je kan in het Nederlands antwoorden als je dat makkelijker vindt)

Hi @Hans Vogelaar

Ja inderdaad ik heb voor bepaald onderhoud een vaste eenheid en een vaste prijs per eenheid. Die wil ik afhankelijk van de optie automatisch laten invullen, bijvoorbeeld Houten gevel bekleding in m2 en 40 euro per m2

Als je weet hoe dit heet dan lukt het vaak wel via youtube maar ik heb geen idee

@Remco_Verduin 

Je zou op een werkblad (bijvoorbeeld het werkblad Lijsten in het werkboek dat ik bijvoegde) de standaard-waarden kunnen aangeven - zie bijgevoegde versie.

@Hans Vogelaar 

Hi als ik ditzelfde wil doen met een klant id nummer en dan automatisch gegevens wil laten invullen?

Remco_Verduin_0-1631694998633.png

Remco_Verduin_1-1631695034929.png

Ik wil dat als ik het klant nummer kies dat hij automatisch naam adres etc invult. Weet jij hoe dit werkt?

 

Groetjes, Remco

 

@Remco_Verduin

De klantcode CU0001 staat in B13 ip.v. B12, en de klantcodes op het blad Relatie gegevens staan in een kolom, dus je moet VERT.ZOEKEN gebruiken i.p.v. HORIZ.ZOEKEN:

 

Voor de klantnaam:

=VERT.ZOEKEN(B13;'Relatie gegevens'!A:D;2;ONWAAR)

Voor de contactpersoon:

=VERT.ZOEKEN(B13;'Relatie gegevens'!A:D;3;ONWAAR)

En voor het type:

=VERT.ZOEKEN(B13;'Relatie gegevens'!A:D;4;ONWAAR)

Ongelofelijk werkt in 1 keer. Je bent een Held met hoofdletter H