I've adapted the following formula from "How to lookup a value..." from
Office Online:

=IF(ISERROR(INDEX($A$2:$F$1007,SMALL(IF($B$2:$F$10 07=G$1,ROW($A$2:$A$1007)),ROW(1:1)),1)),"",INDEX($ A$2:$F$1007,SMALL(IF($B$2:$F$1007=G$1,ROW($A$2:$A$ 1007)),ROW(1:1)),1))

date no1 no2 no3 no4 no5 1
6/7/2008 2 4 11 15 28 6/24/08
6/10/2008 8 13 14 23 30 6/28/08
6/14/2008 5 13 24 35 45
6/17/2008 10 12 18 30 36
6/21/2008 1 2 5 23 45
6/24/2008 1 4 37 45 46


However, the date that is returned is from the row BELOW the I would like.
In other words, in column "1" the dates 6/21/2008 and 6/24/2008 should
appear. Any suggestions? Many thanks.

Bud