I have a database that I need to do some index/matching on. One
result would be the value of the lowest score for today's date. The
other would be the center (CREG, CHI, EKA etc) with the lowest score.
I am using the small function because I will eventually need to adjust
my formula for the 2nd, 3rd and 4th lowest scores.

I have tried for some time with a formula =INDEX(B1:F1,MATCH(TODAY
(),A1:A7),SMALL(B2:F7,1),B2:F7)

data below starts in cell A1

Date CREG CHI EKA ELK FRO
11/06/08 21.9 -24.7 56.4 39.8 3.2
11/07/08 24.0 93.2 10.8 79.8 72.8
11/10/08 4.1 55.9 85.4 -188.7 49.6
11/11/08 36.0 77.8 35.4 -42.0 -10.9
11/12/08
11/13/08


Thanks, Steve