Trying to select a name out of a cell given by certain critera within an adjacent cell.

First post here I go!

I've got a table, names of events line the top of the table, names of the races line the side, and their times will in the table. Each racer can only race 3 events so I'm trying to keep track of that using an =countif(range, criteria) cell, thats working great. ( That is displayed to the left of the racers name.

What I need next is finding the fastest person in the race, I'm using a =SMALL(range, k) to get the smallest time, which is working out well, but I want to display the person who has that time, not the time itself.

Is there anyway that I can do this?

Thanks for the help,
-Damien Kahmer

Sure thing, will do, names on it I believe are confidential so give me a minute to adjust some criteria, thanks for the help!

RacerTest.xlsx

Alright here we go,

The colored backgrounds are a visual representation off the fastest times, the Column titled Value, gives the racers a quality value based on their times total. Note that on the left side it has events to display number of events. They are all 0 now because they don't have any of their names showing up in the racing area on the right.

For example in Race One on the right, the person in first has a fastest time of 24.6, which is correct in that it corresponds to the race one column on the left. I don't want it to display 24.6 though on the right I want it to display "Racer 8".

Alright so the way I'm understanding is I would use the vlookup as the main portion of the function and the actual finding fastest time, as a nested function? The helper function being just labeled 1-10 for each racer?

I understand what you mean, I just don't see how that comes into play,

VLookup( value, table_array, index_number, not_exact_match )

has no where to get fastest time, then display the other column. Unless the original =small is the new table array?

I've been messing around with this vlookup, but I can't seem to figure out how to do this.

RacerTest.xlsx

That's the one I've included the Vlookup on. Still just trying to get race 1, fastest time, and display the racers name that's housed in column1.

Thanks for the help so far, but I still need some more.

Oh man! My browser didn't display the link of what you attached, that works perfect! Is there a reason though that the helper column is needed and that it can't just be the original Racer # one?