Using lookup function on values that are the same only returns one value

I am using the small function to order times from another sheet.

From there, I am using the lookup function to retrieve text in a cell next to that time. This works well except when there are duplicate times.

If I use lookup, I get the first text alphabetically.
If I use Index match, I get the top text on the other sheet.

There may be the same text associated with the same time, so that would have to be considered. ie
NAME1 23sec
NAME2 23sec
NAME1 23sec

Does anyone know any way around this?

Thanks

Thanks, Ill try it out.

I dont know how to add the table in here so I am having trouble explaining.

In your example, column B is in ascending order from a small function from data in another sheet. This works fine. Column A is what I am having problems with acquiring both names that have that 23sec time. Im always getting one name and not the next name with that same time. Column C doesn't matter.

Pretend the below are tables:

SHEET WITH DATA NOT IN ASC. ORDER
name3 name5 name 5 20sec
nameA nameB name C 16sec
name4 name4 name 4 19sec
name1 name2 name 3 21sec
namex namex name x 17sec
namea nameb namec 17sec

SHEET W/ FUNCTIONS
nameA nameB name C 16sec <---WORKS
namex namex name x 17sec <---WORKS
namex namex name x 17sec <---BROKEN - should be namea,b,c
name4 name4 name 4 19sec <---WORKS
name3 name5 name 5 20sec <---WORKS
name1 name2 name 3 21sec <---WORKS

With "input" in columns A1:D6

in E1

=INDEX(A$1:A$6,MATCH(SMALL(COUNTIF($D$1:$D$6,"<="&$D$1:$D$6)+ROW($A$1:$A$6)/10^5+$D$1:$D$6,ROWS($A$1:$A1)),COUNTIF($D$1:$D$6,"<="&$D$1:$D$6)+ROW($A$1:$A$6)/10^5+$D$1:$D$6,0))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

THEN copy across and down

I uploaded a file but I dont see it here.

Thanks John, Ill give it a try.