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 is FT i need value from First col, and if it is SQY then 3rd column
Any suggestion how to bring this lookup ?
1 Reply
Use a switch statement. something like
ColF = SWITCH([Unit],
"SQM", SELECTEDVALUE([SQM]),... etc.
)
