Code:

`{=IFERROR(INDEX(Data!$Y$9:$Y$561,SMALL(IF(Data!$Y$9:$Y$561>=Data!$Z$3,ROW(Data!$C$9:$C$561)-ROW(Data!D$9)),ROWS(Data!Y$9:Data!Y10))),"")}`

I have a table with duration values in column Y with the criteria in cell Z3. This formula currently returns the correct column but the criteria part isn't working correctly. If I remove that part and keep the rest as:

Code:

`{=IFERROR(INDEX(Data!$C$9:$C$561,SMALL(IF(Data!$Y$9:$Y$561,ROW(Data!$C$9:$C$561)-ROW(Data!C$9)),ROWS(Data!C$9:Data!C10))),"")}`

Then it starts populating with the first row.

thank you for any help!