Get the values on row by row (Continuation)

Hi guys,

Need help on this, thank you in advance.


I already got the values on Row B and C, what should I add in the formula to get also the values on the Row D.


With SHIFT+CTRL+ENTER: =IFERROR(IFERROR(INDEX($B$2:$B$9,SMALL(IF($A$2:$A$9=$G$1,ROW($A$2:$A$9)-ROW($A$2)+1),ROWS($A$1:A1))),INDEX($C$2:$C$9,SMALL(IF($A$2:$A$9=$G$1,ROW($A$2:$A$9)-ROW($A$2)+1),ROWS($A$1:A1)-SUMPRODUCT(--($A$2:$A$9=$G$1))))),""))

Index.png

Perhaps

=IFERROR(IFERROR(IFERROR(INDEX($B$2:$B$9,SMALL(IF($B$2:$B$9<>"",ROW($B$2:$B$9)-ROW($B$2)+1),ROWS($A$1:A1))),INDEX($C$2:$C$9,SMALL(IF($C$2:$C$9<>"",ROW($C$2:$C$9)-ROW($C$2)+1),ROWS($A$1:A1)-ROWS($B$2:$B$9)))),INDEX($D$2:$D$9,SMALL(IF($D$2:$D$9<>"",ROW($D$2:$D$9)-ROW($D$2)+1),ROWS($A$1:A1)-ROWS($B$2:$B$9)-ROWS($C$2:$C$9)))),"")

hope this helps

Hi Azumi,

I think the value that needs to lookup is missing on the formula.

Thanks for helping by the way

Ahh yes you have criteria, have fix it

Please disregard my last reply.


@Azumi, thanks again.