Extract Values from F15:S20 into F3:S10 if Condition Met

New modification:
Looking for formula (preferably non-array) to look into B13:S20 and (see desired outcome in F3:S10) and extract values in F15:S20 into F3:S10. Requirements to extract values are date in F2:S2 and E14:S14, ID in E3:E10 and E15:E20, and names in B3: B10 and B15:B20.

See attached sample file.

Thanks




Modified request I: Solved
Looking for formula (preferably non-array) to look into A2:F9 and return unique values for the names (see desired outcome in A14:R19) and extract values in E2:E9 into E14:R19. Requirements to extract values are date in F2:F9, names and E13:R13.

Desired outcome is in B14:R19. See attached sample file.

Modified request II:
Looking for formula (preferably non-array) to look into A2:F9 and (see desired outcome in A23:R32) and extract values in E2:E9 into E24:R31. Requirements to extract values are date in F2:F9, names and E23:R23.

Desired outcome is in B24:R31. See attached sample file.



Original Request: Solved
Looking for formula (preferably non-array) to look into A3:R10 and return unique values for the names (see desired outcome in A13:R20) and extract values in H3:R10 into E15:R20. Requirements to extract values are date in H2:R2, names and E14:R14.

Desired outcome is in B15:R20. See attached sample file.

Thanks.

One more approach without passive function. In E15 then copied across.

Please Login or Register  to view this content.

Please try at
A15:A20
=IFERROR(INDEX(A$3:A$10,AGGREGATE(15,6,ROW($B$3:$B$10)-ROW($B$2)/(MATCH($B$3:$B$10,$B$3:$B$10,)=ROW($B$3:$B$10)-ROW($B$2)),ROWS(B$15:B15))),"")

B15:D20
=IF($A15="","",VLOOKUP($A15,$A$3:$D$10,COLUMNS($A15:B15),))

E15:R20
=IFERROR(INDEX($E$3:$E$10,MATCH(TRUE,INDEX($B$3:$B$10&INDEX($H$3:$R$10,,MATCH(E$14,$H$2:$R$2,))=$B15&$E$3:$E$10,),)),"")

johnmpl: Oustanding solution, johnmpl. Thank you, johnmpl.

Modified request:
Looking for formula (preferably non-array) to look into A3:R10 and (see desired outcome in A23:R32) and extract values in H3:R10 into E25:R32. Requirements to extract values are date in H2:R2, names and E24:R24.

Desired outcome is in B24:R32. See attached sample file.

B25:R32
=iferror(vlookup($a25,$a$3:$r$10,match(b$24,$a$2:$r$2,),)&"","")

In E14 then copied across

Please Login or Register  to view this content.

Pl see attached file with formulas in both the ranges.

kvsrinivasamurthy: You are simply the best - excellent solution. I have one more modification.

New modification:
Looking for formula (preferably non-array) to look into B13:S20 and (see desired outcome in F3:S10) and extract values in F15:S20 into F3:S10. Requirements to extract values are date in F2:S2 and E14:S14, ID in E3:E10 and E15:E20, and names in B3: B10 and B15:B20.

See attached sample file.

Thanks

In F3 then copied across

=IFERROR(INDEX($F$15:$S$20,MATCH($B3,$B$15:$B$20,0),MATCH(F$2,$F$14:$S$14,0)),"")

Revised formula in F3

Please Login or Register  to view this content.