Refer to a list value in creating a conditional column

[laganlee]

Hi,

I want to create a conditional column that uses a value from a list.

So for example I want to use the third value (50) in the list in the new column:

The calculation for the new column would be third list value (50) x value (22) = 50 x 22 

How do I do that?

Many thanks for looking

[laganlee]

Awesome! thanks 😎  

[AlienSx · Accepted solution]

Hi, @laganlee 

Lookup{2} * [value]