Index Formula

[christian2016]

Hi Guys,

I have the below formula

=IF(ISERROR(INDEX(Sheet1!$B$11:$C$24,SMALL(IF(Sheet1!$B$11:$C$24=TRUE,ROW(Sheet1!$B$11:$B$24)),ROW(1:1)),2)),"",INDEX(Sheet1!$B$11:$C$24,SMALL(IF(Sheet1!$B$11:$C$24=TRUE,ROW(Sheet1!$B$11:$B$24)),ROW(1:1)),2))


Although is not work. If i change the B11 to B1 it will work correctly, although my data starts in cell B11. Don't know if I have to change the rows or column. I have tried it multiple times unable to get it to work.

Please refer to spreadsheet.

Any help is greatly appreciated

[AliGW]

Please provide a version of your workbook with expected outcomes mocked up where you want to see them.

[xlnitwit]

Hi,

Perhaps you mean something like this
=IFERROR(INDEX(Sheet1!$B$11:$C$24,SMALL(IF(Sheet1!$B$11:$C$24=TRUE,ROW(Sheet1!$B$11:$B$24)-ROW($B$11)+1),ROWS($A$1:$A1)),2),"")

[FDibbins]

Perhaps this?
=IFERROR(INDEX(Sheet1!$C:$C,SMALL(IF(Sheet1!$B$6:$B$8=TRUE,ROW(Sheet1!$B$6:$B$8)),ROWS($A$1:A1))),"")
ARRAY entered

You dont need $B$11:$C$24 in the index, you are only returning data from column C
You dont need $B$11:$C$24 to test for TRUE, you only need to look in B