Pecoflyer,

Thanks much. I agree that what you provided works. Array formulas are a bit out of my comfort zone although each time I get a complicated lookup question and ask it on a forum, the answer has always included an array formula. Perhaps I need to become better versed in these.

I also agree that it can be simplified slightly as follows. Do you agree?

You provided the key formula as being:
{=INDEX(INDEX($B$8:$J$31,MATCH($C$1,$B$8:$B$31,0), ),,MATCH(TRUE,(INDEX($B$8:$J$31,MATCH($C$1,$B$8:$B $31,0),))>=$C$2,0))}

I simplified this slightly to:
=INDEX($B$8:$J$31,MATCH($C$1,$B$8:$B$31,0),MATCH(T RUE,(INDEX($B$8:$J$31,MATCH($C$1,$B$8:$B$31,0),))> =$C$2,0))

I was also surprised that the Offset function can have a blank for the second or third argument [e.g. Offset(B1..C5,28,)]. I figured the third argument in this example would have to be a 0. Of course, putting in 0 works but so does leaving it blank.

Thanks again.

G'day,

Vinish