Dec 22 2018 11:14 PM
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.
Dec 23 2018 09:19 AM
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
Feb 19 2019 12:01 PM