This is the formula in I2 (dragdown) using the INDEX-MATCH functions Add equal sign to comparisons if needed.
INDEX-MATCH
=INDEX(D$2:D$9,MATCH(1,(G2=A$2:A$9)*(H2>B$2:B$9)*(H2<C$2:C$9),0))