cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Lookup Function with Variable

Hey to all -

has anyone found a way how to use a variable in the lookup function ?

For example I have a calculated field in my form where I added a formula:

lookup("Condition Factors","ID",cboProducts,***Variable***)

When I enter my variable directly - it works but I want it be flexible, variable will be based on a value of another calculated field.

Any ideas anyone?

Kind regards, Dimitri

Labels: (1)
Reply
1 Reply
Workflow Hero

Re: Lookup Function with Variable

You can use if function

If(CalculatedValue=="test",lookup("Condition Factors","ID",cboProducts,Variable1),If(CalculatedValue=="test1", lookup("Condition Factors","ID",cboProducts,Variable2),""))

 

0 Kudos
Accept as Solution Reply