On Fri, 01 Aug 2008 19:52:13 -0500, Dave Peterson
wrote:

One mo

=if($b37="","",LOOKUP(2,1/($B$2:$B$36=$B37),$C$2:$C$36))

I like empty strings--not single space characters--to make the cell look empty.

That appears to work for me, thanks.