Forum Discussion
Excel Drop Down List conditions
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
- 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 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
