Sort the Values in Column A in Ascending Order & Extract Corresponding Values

Looking for non-array formula to look into A2:D10 and Sort the Values column A into column F2:F10 in ascending order and extract corresponding (Employee ID, Req. and Req. Date) values for the names in column A into G2:I10. Desired outcome is in F2:I10. See sample file.

Thanks

Hi bjnockle,

Please the the attached file with a non-array formula to get the resultat you had.
We are using a helper column.
Note you have dublicates in the Name column by which you want to sort. The formula used allows for that.
Hope this helps.

Below solution sorts first 3 characters, if duplicate, sorts the date in column D, the older, the first.
F2:

Please Login or Register  to view this content.

Drag down and accross.

Please try at F2

=INDEX(A$1:A$10,MOD(AGGREGATE(15,6,COUNTIFS($A$2:$A$10,"<"&$A$2:$A$10)*10^6+ROW($A$2:$A$10),ROWS(F$2:F2)),10^6))

In F2 then copied down

Please Login or Register  to view this content.

In G2 then copied across and down

Please Login or Register  to view this content.

Blank rows (11 to 19) are also included in formula to take care data entry in future without changing formula.

One more way with helper column E and very simple formulas.
In E2 then down

=IF($A2="","",COUNTIF($A$2:$A$19,">="&A2)-ROW()*0.0001)

For table in R2 then copied across

=IFERROR(INDEX(A:A,MATCH(LARGE($E$2:$E$19,ROWS(E$2:E2)),$E$2:$E$19,0)+ROW(E$1)),"")

Try at F2

=IFERROR(INDEX(A$1:A$19,MOD(AGGREGATE(15,6,COUNTIFS($A$2:$A$19,"<"&$A$2:$A$19)/($A$2:$A$19<>"-")*10^6+ROW($A$2:$A$19),ROWS(F$2:F2)),10^6)),"")