Multiple Lookups returning one value

Gaetano_B

Hello and thanks in advance for helping. 

I need a multiple lookups returning one criteria, example below. Any suggestion? I know I could use a formula but the list of values is very extensive hence I was looking for an easier solution.

i.e. if derived stage is equal to "Inactive Lifecycle", Overall Status is equal to "Inactive Lifecycle - Pending Information" and Stage With is equal to "Client, Client Owner" then return Mapping Value "0. Not Started"

Thanks very much,

Gaetano

Jean-Balteryx

@Gaetano_B ,

I attached the example workflow.

Basically, the idea is having a reference table containing your cases and then, using a join, match your criteria in the data with the ones in the references and get the "Mapping" that matches.

Don't hesitate if you have question or need more details.

Kind regards,

Jean-Baptiste

Multiple_Lookups_returning_one_value.yxmd