CREATING MULTIPLE DROP-DOWN LIST BASED ON PRIOR CHOICE

%3CLINGO-SUB%20id%3D%22lingo-sub-1642341%22%20slang%3D%22en-US%22%3ECREATING%20MULTIPLE%20DROP-DOWN%20LIST%20BASED%20ON%20PRIOR%20CHOICE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1642341%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20to%20create%20a%20form%20that%20will%20require%20drop%20down%20options.%20I%20learned%20how%20to%20create%20a%20drop-down%2C%20but%20how%20do%20you%20create%20a%20new%20drop-list%20based%20on%20the%20selections%20from%20the%20previous%20drop%20down%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEx%3A%20Column%20A%20has%203%20options%3A%20Med%2C%20Vision%2C%20Dental.%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20B%20would%20have%20the%20drop%20down%20list%20based%20on%20the%20selection%20choice%20from%20Column%20A%3C%2FP%3E%3CP%3EColumn%20C%20would%20have%20the%20drop%20down%20list%20based%20on%20the%20selection%20choice%20from%20Column%20B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20header%20would%20be%3A%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20A%20-%20BENEFIT%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20B%20-%20PLAN%3C%2FP%3E%3CP%3EColumn%20C%20-%20AMOUNT%20CHARGE%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20appreciate%20your%20time%20and%20effort%20educating%20me%20on%20creating%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%26nbsp%3B%3C%2FP%3E%3CP%3EHR%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1642341%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-1642591%22%20slang%3D%22en-US%22%3ERe%3A%20CREATING%20MULTIPLE%20DROP-DOWN%20LIST%20BASED%20ON%20PRIOR%20CHOICE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1642591%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F784883%22%20target%3D%22_blank%22%3E%40HR2020%3C%2FA%3E%26nbsp%3B%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%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1701872%22%20slang%3D%22en-US%22%3ERe%3A%20CREATING%20MULTIPLE%20DROP-DOWN%20LIST%20BASED%20ON%20PRIOR%20CHOICE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1701872%22%20slang%3D%22en-US%22%3E%3CP%3ETHIS%20IS%20AWESOME!!!%26nbsp%3B%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%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20sharing!!%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-smiling-eyes%22%20title%3D%22%3Agrinning_face_with_smiling_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%26nbsp%3B%3C%2FP%3E%3CP%3EBonnie%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, 

 

I am having to create a form that will require drop down options. I learned how to create a drop-down, but how do you create a new drop-list based on the selections from the previous drop down list?

 

Ex: Column A has 3 options: Med, Vision, Dental. 

Column B would have the drop down list based on the selection choice from Column A

Column C would have the drop down list based on the selection choice from Column B

 

The header would be: 

Column A - BENEFIT  

Column B - PLAN

Column C - AMOUNT CHARGE

 

I appreciate your time and effort educating me on creating this. 

 

Regards, 

HR

 

 

2 Replies

THIS IS AWESOME!!! @Hans Vogelaar 

 

Thanks for sharing!!  

 

Kind regards, 

Bonnie