On Fri, 01 Aug 2008 21:23:42 GMT, Lars-Åke Aspelin
wrote:

If you always have at least one match, you may try this formula in
cell C37:

=IF($B37"",INDEX(C$1:C36,LARGE(ROW(B$2:B$36)*($B 37=$B$2:$B36),1)),"")

I put in a new row each week, whenever there is a new value in the B
column, I overtype the C formula with its corresponding new value.

My first set of values is in row 3, I have the formula currently set
to go to row 100, although I only have the first 50 rows populated
with data. Your formula displayed #### for me.