How do I make a cell show (List #1) IF (Condition #1 is met), BUT Show (List # 2) IF (Condition # 2 is met)? So on, and so on.
I have about 50 Different list's I want a single cell to show, Depending on the conditions in the cell's above it.
I tried entering my formula into the Data Validation, but that only accepts a single formula (No Nesting)
Please help.
Thanks :)
Solved by I. J. in 18 mins