# Find Lowest Time, Match with Column Heading

1. ## Find Lowest Time, Match with Column Heading

I want to set up an excel spreadsheet that does the following:

Tracks the best marks of an athlete and puts in their corresponding meet...

B2: Finds the lowest (or highest) number in the row (I figured that out using MIN and MAX formulas),

B3: In the next column have the corresponding header go with the min or max that it just formulated...

ie if you have data B4:H4,
A4=Meet 1, A5=Meet 2, A6= Meet 3, etc
and B4=3, B5=2, B6=1
then B2 would be the lowest score (B6)
and B3 would be Meet 3

Any help is appreciated!

2. ## Re: Find Lowest Time, Match with Column Heading

Try this,
C2
=INDEX(\$D\$1:\$H\$1,1,MATCH(B2,D2:H2,0))

Copied down

Hope this helps,
windknife

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1