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 ?