Trouble with IF or LOOKUP string

[wmncville]

Hi, I'm rather new to Excel and am having trouble writing a string correctly for this scenario:

If E2 input value = 2, 35, 82, 266, 268, 278, 281, 373, 645, 646 or 744 output PM, else if E2 is another value then:
If F2 input value =D, output AMI, else if F2 is another value then:
If H2 input value is 1-6, output PM
If H2 input value is 7-16, output TS
If H2 input value is 30-39, output SQ
If H2 input value =40, output CP
If H2 input value is 50-59, output EP
If H2 input value is 60-69, output BR

Like this:
E F G H I (OUTPUT)
35 C DF 7 PM
82 C DF 10 PM
511 D DF 7 AMI
627 C DF 50 EP

Thank you very much for any help!

[sweep]

Hi,

Does this get you anywhere close?

=IF(OR(E2={2,35,82,266,268,278,281,373,645,646,744}),"PM",IF(F2="D","AMI",LOOKUP(H2,{1,7,17,30,40,41,50,60,70},{"PM","TS","","SQ","CP","","EP","BR"})))

[wmncville]

This worked perfectly. Thank you so much!

Do you have any online tutorials you recommend?