IF Function that produce multiple "value_if_true" outcomes
I posed a similar question early last week but It hasn't worked. I have two columns, "Department" and "Analyst". I use an IF function that says, if this department then that analyst, etc.
At times, the Department Row can list MULTIPLE departments as shown below. Is it possible to have an IF function that can recognize two departments and list TWO different individuals? I know I could create a longer IF function but that would be hundreds of different combinations.
I have tried to use a IF(CONTAINS( function, but it won't list two analysts.
Help Article Resources
Check out the Formula Handbook template!