Lookup Value for based on Certain Criteria [Solved]

[Little Master]

Dear All,

Need your help with regards to captioned scenario.

I have one work with Sheets named Input & Output.

In Input Sheet I have 4 columns named Type, Login Date, Customer Name, Status
In Output Sheet I need output only for particular type. Dummy Sheet attached for reference.

Any kind of help is appreciated.

Thanks in advance.

[Fotis1991]

Try in B2, this ARRAY formula.

=INDEX(Input!C$2:C$100,SMALL(IF(Input!$A$2:$A$100=$A2,ROW(Input!C$2:C$100)-1),ROW(Input!C1)))

Copy down and across.

[:) Sixthsense :)]

In B2 cell of Output Sheet - Array Formula Requires Ctrl+Shift+Enter

=IFERROR(INDEX(Input!$C$2:$D$16,SMALL(IF(Input!$A$2:$A$16=$A2,ROW(Input!$A$2:$A$16)-1),COUNTIF($A$2:$A2,$A2)),COLUMN(A$1)),"")

[Little Master]

Thanks to both of you. Both Formulas worked for me.

[Fotis1991]

...................