Glad it worked, thanks for the feedback.

Kostis

On Nov 14, 12:49*am, SteveR wrote:
On Nov 13, 1:44*pm, SteveR wrote:



On Nov 13, 12:24*pm, vezerid wrote:

This is because I assumed you would like these results for every day
and I misread your use of TODAY(). So in K2,

=INDEX($B$1:$F$1,MATCH(SMALL(INDEX($B$2:$F$7,MATCH (TODAY(),$A$2:$A
$7,0),0),K$1),INDEX($B$2:$F$7,MATCH(TODAY(),$A$2:$ A$7,0),0),0))

HTH
Kostis

Thanks Kostis , but that does not include anything for the date lookup
I need.- Hide quoted text -

- Show quoted text -

Thanks Kostis- that worked perfectly!
Now that I have the four centers with the lowest scores, how can i
actually return their scores ?
I tried to amend your fomula but did not come up with their scores

Thanks, Steve- Hide quoted text -

- Show quoted text -

I figured it out (finally) Thanks for your help Kostis !