Here's one way......

=((F3=1)*OR(G3={5,6,7}))+((F3=2)*OR(G3={7,8,9}))+(OR(F3={3,4})*OR(G3={9,10,11}))