Lookup selection IF THEN ELSE()
Posted: Sun Jun 29, 2025 5:24 pm
Hi,
I have two lookup tables for fluid properties. I am trying to select between two fluids. Using the IF THEN ELSE() function, I am not allowed to select lookups. "Argument 2 to IF THEN ELSE can not be a Lookup."
What should I do instead of:
IF THEN ELSE(fluid=1, fluid1 lookup, fluid2 lookup)?
I have two lookup tables for fluid properties. I am trying to select between two fluids. Using the IF THEN ELSE() function, I am not allowed to select lookups. "Argument 2 to IF THEN ELSE can not be a Lookup."
What should I do instead of:
IF THEN ELSE(fluid=1, fluid1 lookup, fluid2 lookup)?