Selecting only one value from multiple rows

[Qlikview1]

Hi,
i'm trying to create a column Cols Final (Row based on Colors) preferably using expression.

the logic is :if the Colors = column, retrieve the Row valueif the Colors <> any of the column'value, retrieve the value where Colors > Column for the first time.Basically it is similar to approximate lookup in excel.. 

Based on the table of example below, becuase the colors is 2 then we need to show only row with value of 150 since 2 <= 3.

However, if its not possible to be conducted in expression, then kindly help us to create the script.

[ogster1974]

using an front end expression able to achieve with measure and above function.