Non Array to extract values if condition is met

[bjnockle]

Looking for non-array formula to look into A2:C10 and extract the correct values using E1 as the requirement to pull values into G2:G6 and H2:H6. Desired outcome is in G2:G6 and H2:H6. See sample file.

Requirement: E1: Feb, Mar

Thanks

[Phuocam]

Try this in G2:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$10)/($C$2:$C$10=$E$1),ROWS(G$2:G2))),"")

[bjnockle]

Phuocam: Not pulling correctly when I adjusted the formula to this:

Please Login or Register  to view this content.

Please help fix. Thanks

[Phuocam]

=IFERROR(INDEX($A$2:$A$10,AGGREGATE(15,6,ROW(A$2:A$10)/($C$2:$C$10=$E$1),ROWs(G$2:G2))-1),"")

[bjnockle]

Phuocam: Proposed formula (

Please Login or Register  to view this content.

solution works pulling values in column A into column G. Would like a non-array to pull the corresponding values (column B - dates) for column A to be pulled into column H.

Thanks

[XLent]

use the formula provided in post#2, in G2, and copy down and to right and you will get the desired results in both Cols G (A) & H (B)

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$10)/($C$2:$C$10=$E$1),ROWS(G$2:G2))),"")

there is no need to modify the initial INDEX range from A:A