Since B1:F1 is one-dimensional INDEX only needs one more argument. I
assume you would like four additional columns to the right, headed
with 1, 2, 3, 4 in, say K1:N1. Each column will report the center with
the nth lowest number, with one set for each day. The following
formula in K2 can be copied down and across:

INDEX($B$1:$F$1,MATCH(SMALL($B2:$F2,K$1),$B2:$F2,0 ))

HTH
Kostis Vezerides

On Nov 13, 9:28*pm, SteveR wrote:
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