I am attempting to display on a weeksheet, the fastest time ran on a given race. I have tried vlookup, and min function, and IF's... obviously I'm stuck.

On the enclosed file you will find that two columns are highlighted. The first is the length of the given race, and is what the cell will be looking for on the main worksheet.
The second column is the time.

On the main page is lists
3.1
6.2
13.1
26.2
What I would like it to do it list the fastest time ran for each distance next to it.
The list is currently short, but will grow very long.

=IF(COUNTIF($C$2:C2,C2)>1,"",MIN(IF($C$2:$C$21=C2, $I$2:$I$21))). This is an array formula, CTRL + SHIFT+ ENTER to commit and copy down. You can also format the cells as "[h]:mm:ss;;;"

This is an array formula so when you type in the formula, you'll need to hit CTRL,SHIFT,ENTER at the same time to put {} around the formula. You'll need to adjust the ranges to fit accordingly.

I am currently using MS-Excel 2003. Having a terrible time with Vlookup. The concept seems easy enough – but I can’t get it to work with just 2 spreadsheets – and pulling only 1 column from the other spreadsheet.
I have these fields on one spreadsheet.
Worksheet Tab 1 Worksheet Tab 2...