MULTI CONDITIONAL STATEMENT

[mrc]

i am using a multi conditional formula if statement to replace the output based on the critieria. I have 80 unique records that need to be output based on meeting the criteria. Here is the formula - 

ELSEIF [State] = "Georgia" and [Company] = "ABC" AND [Unique Identifier] = "1001123" THEN "123"

ELSEIF [State] = "Georgia" and [Company] = "ABC" AND [Unique Identifier] = "1001124" THEN "333"

My question is can this be done in a more efficient way or do I have to repeat this formula 80 times for the 80 unique answers.  Thank you for any help!

[JosephSerpis · Accepted solution]

Hi @mrc a possible way would be to use a join tool if you have the data for criteria replacement as a data input. I mocked up a workflow to showcase such an approach.

[mrc]

Yes, I think that would be the better solution. THANK YOU!!