Originally Posted by Spencer101

Try the below formula in cell C4. Confirm it as an array formula (press Ctrl, Shft & Enter rather than just enter) and copy down.

=INDEX(I$4:I$11,MATCH(1,(E$4:E$11=A4)*(G$4:G$11<B4 )*(H$4:H$11B4),0))

You'll know it's been correctly entered as an array formula when Excel puts curly brackets around the whole formula.

Hope that helps.

S.