Try this:

=MAX((A1:A1000>=F1)*(A1:A1000<G1)*E1:E1000)
confrimed with Ctrl-Shift-Enter.

Cheers,