Try:

=--(AND(VLOOKUP(C4,$E$4:$G$15,3,0)>=$B$1,VLOOKUP(C4,$E$4:$G$15,3,0)<=$B$2))