Home

Excel Drop Down List conditions

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