Select LESS THAN Column

[jayman7]

Hi,

I am trying to select a reference cell value from a column that is LESS THAN.

1. My reference cell value is 22.

2. I look at first row and since 22 < 30, I want to pick values in column 3 (30)

3. Question, how would I get the output below my reference output 22, like i have below?

Thanks in advance,
j

10	20	30		22
11	21	31		31
12	22	32		32
13	23	33		33