Lookup against multiple column

[Aravind_Kumar]

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 ?

[vicky_]

Use a switch statement. something like
ColF = SWITCH([Unit], 
    "SQM", SELECTEDVALUE([SQM]),

    ... etc.

)