Row B has Names and Row C has their corresponding race times

I assume that's supposed to be column B has names and column C has times?

I'm trying generate a Top 10 times list

I'm assuming that the lowest times are the better times so you want the
names that correspond to the 10 lowest times?

Are there any duplicate times(ties)? If so, it gets kind of complicated and
it also depends on what your definition of a top 10 list includes. For
example, a top 10 list can have more than 10 items. Consider this example:

1
1
2
2
2
3
3

If you want the top 3 (lowest = best), how many comprise the top 3?

Names in the range B1:B100
Times in the range C1:C100

Enter this formula in E1 and copy down as needed:

=INDEX(B$1:B$100,MATCH(SMALL(C$1:C$100,ROWS(E$1:E1 )),C$1:C$100,0))

If there are ties that fall within the smallest n you'll get incorrect
results for those ties.

--
Biff
Microsoft Excel MVP


"thscc1659" wrote in message
...
I'm trying to use the LOOKUP function to search a LOOKUP VECTOR that is
not
in ascending order. Putting the values in ascending order is not an
option.
Is there any way to use LOOKUP with these values?

Row B has Names and Row C has their corresponding race times in
chronological order. I'm trying generate a Top 10 times list (with the
corresponding names) from the data.