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....
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