Need help taking an if statement and making a lookup table

[Rwebber1991]

I have changed variable names and excluded quite a bit of logic in the workflow because some may be sensitive information but it should be enough to describe my problem. I need to take existing logic for a field that is currently created using an if statement and create a lookup table where I can instead map the created field by joining on the two fields used in the if statement. I have included a workflow with the logic and an example for what I am looking to do. I just can't figure out how I can take the various permutations of the if statement and quickly create a lookup table. If you can help me I will greatly appreciate it.

[IraWatt]

Hey @Rwebber1991,

This join applies the same logic as your formula:

It joins on both of your fields. If you have any questions make sure to ask :)

HTH,

Ira