I need to take 2 values among 4 columns and merge them or find another way to make a single value from them, and relate to another column. Then, I need to Lookup values based on this relation, but is not working how I minded. My idea, was to make a template and replace the variables, so with this merged value, my relation could link the columns that I want.
Unfortunately, the IF THEN ELSE don’t have a “AND” possibility, otherwise I think this could solve this.
Anyone can help me on this one?
Relate the 2 values of this 4 columns with one another column with merged possibles results, then lookup for other values on that row.
This is what I’ve tried:
TEMPLATE > REL > LOOKUP
I want to relate with this column and lookup their respective values