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