Select LESS THAN Column

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

An example file would probably help in this instance... however if for the sake of demo we assume your sample data table is in A1:C4 and criteria is in D1 with values to be returned in D2:D4 then

D2: =INDEX($A2:$C2,1+COUNTIF($A$1:$C$1,"<"&$D$1))
copied down

Though as you can see from the above you're constantly recalculating the COUNTIF element in which the result is constant... it would therefore make more sense then to store that calculation in E1 and then refer to just that cell from then on, eg:

E1: =1+COUNTIF($A$1:$C$1,"<"&$D$1)

D2: =INDEX($A2:$C2,$E$1)
copied down