Thanks Just_jon, That worked perfectly. Thanks also to Herbert.

"just_jon" wrote:

Absolutely, missed a set of parens --

=LOOKUP(2,(1/((A3:A11<=A13)*(B3:B11=A13)*(C3:C11<=A14)*(D3:D11 =A14))),INDEX(E3:G11,0,MATCH(A15,E2:G2)))