Lookup based on Cell Criteria

Array formula ensure [shift+ctrl+enter]
In "A3"

Formula:

=IFERROR(INDEX(owssvr!F:F,SMALL(IF($F$1=owssvr!$E$2:$E$8,ROW(owssvr!$E$2:$E$8)),ROWS(A$2:A2))),"")

In "B3"

Formula:

=IFERROR(INDEX(owssvr!B:B,SMALL(IF($F$1=owssvr!$E$2:$E$8,ROW(owssvr!$E$2:$E$8)),ROWS(B$2:B2))),"")

In "C3"

Formula:

=IFERROR(INDEX(owssvr!C:C,SMALL(IF($F$1=owssvr!$E$2:$E$8,ROW(owssvr!$E$2:$E$8)),ROWS(C$2:C2))),"")

In "D3"

Formula:

=IFERROR(INDEX(owssvr!D:D,SMALL(IF($F$1=owssvr!$E$2:$E$8,ROW(owssvr!$E$2:$E$8)),ROWS(D$2:D2))),"")

copy down till blank.