Home

Excel Drop Down List conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-306038%22%20slang%3D%22en-US%22%3EExcel%20Drop%20Down%20List%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-306038%22%20slang%3D%22en-US%22%3E%3CP%3EHOW%20DO%20I%20CREATE%20DROP%20DOWN%20LISTS%20BASED%20ON%20CRITERIA%3A%20FOR%20EXAMPLE%20BASED%20ON%20CRITERIA%20SELECTED%20IN%20COLUMN%20C%2C%20THE%20DROP%20DOWN%20LIST%20SHOULD%20POP%20UP.%26nbsp%3B%20I%20HAVE%20FOUR%20DIFFERENT%20TYPES%20OF%20LISTS%20TO%20BE%20USED%20IN%20DROP%20DOWN.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-306038%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edrop%20down%20list%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353557%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Drop%20Down%20List%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353557%22%20slang%3D%22en-US%22%3EThe%20dynamic%20dependent%20drop-down%20list%20solution%20for%20you%20is%20similar%20to%20my%20reply%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FData-validation-lists-flow-chart%2Fm-p%2F352333%23M25764%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FData-validation-lists-flow-chart%2Fm-p%2F352333%23M25764%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-306113%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Drop%20Down%20List%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-306113%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20think%20you%20can%20do%20that%20without%20visual%20basic.%20A%20work%20arround%20could%20be%20to%20have%20conditional%20formulas%20that%20changes%20the%20actual%20list.%20You'd%20need%20an%20additional%20list%20made%20of%20formulas%20and%20if%20conditions%20A%20are%20met%2C%20then%20the%20values%20%3D%20A%2C%20if%20B%20then%20val%3DB%20and%20so%20forth.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20it%20make%20sense%3F%20your%20main%20list%20should%20be%20%3Dif(condA%2Cval_fromA%2Cif(condB%2Cval_fromB%2Cval_fromC))%3C%2FP%3E%3CP%3EThis%20for%20each%20line%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Srinivase
Occasional Visitor

HOW DO I CREATE DROP DOWN LISTS BASED ON CRITERIA: FOR EXAMPLE BASED ON CRITERIA SELECTED IN COLUMN C, THE DROP DOWN LIST SHOULD POP UP.  I HAVE FOUR DIFFERENT TYPES OF LISTS TO BE USED IN DROP DOWN.

2 Replies

I don't think you can do that without visual basic. A work arround could be to have conditional formulas that changes the actual list. You'd need an additional list made of formulas and if conditions A are met, then the values = A, if B then val=B and so forth.

 

Does it make sense? your main list should be =if(condA,val_fromA,if(condB,val_fromB,val_fromC))

This for each line

 

The dynamic dependent drop-down list solution for you is similar to my reply here:
https://techcommunity.microsoft.com/t5/Excel/Data-validation-lists-flow-chart/m-p/352333#M25764
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies