Hi,

I'm new here, and I really need your help.

Scenario: I already got the value on the Row (B), is it possible to get also the value on the Row (C) after getting all the value on the Row (B)

This is the formula I used: =IF(ISERROR(INDEX($A:$C,SMALL(IF($A:$A=$F$1,ROW($A:$A)),ROW(1:1)),2)),"",INDEX($A:$C,SMALL(IF($A:$A=$F$1,ROW($A:$A)),ROW(1:1)),2))

Thank you in advance

Screenshot 2016-02-10 at 15.03.20.png