Forum Discussion
Lookup against multiple column
Hello : My Data looks like above (A to E) and Column F in Green is what i need to populate. I have 3 different column to look up based on the value in Columne E / Unit ? For example if unit...
Use a switch statement. something like
ColF = SWITCH([Unit],
"SQM", SELECTEDVALUE([SQM]),
... etc.
)