IF, Vlookup and N/A & text issues

[SB1976]

Hi,

I would like a formula to report data in cell M11. I'd like to start by looking up data in cell E11 and if it is less than 3000 to report it as "NT", if it is greater than 3000, I'd like cell H11 to be looked at and checked against a list of codes. If one of these codes appears I'd like "NT" to be reported. If the code doesn't appear I'd like "T" to be reported.

If anyone could help it would be great!

[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl65"]Z1220[/TD]
[TD="class: xl65, width: 64"]NT[/TD]
[/TR]
[TR]
[TD="class: xl65"]Z1230[/TD]
[TD="class: xl65"]NT[/TD]
[/TR]
[TR]
[TD="class: xl65"]Z2000[/TD]
[TD="class: xl65"]NT[/TD]
[/TR]
[TR]
[TD="class: xl65"]Z2002[/TD]
[TD="class: xl65"]NT[/TD]
[/TR]
[TR]
[TD="class: xl65"]Z3000[/TD]
[TD="class: xl65"]NT[/TD]
[/TR]
[TR]
[TD="class: xl65"]Z3010[/TD]
[TD="class: xl65"]NT[/TD]
[/TR]
[TR]
[TD="class: xl65"]Z3100[/TD]
[TD="class: xl65"]NT[/TD]
[/TR]
[TR]
[TD="class: xl65"]Z3200[/TD]
[TD="class: xl65"]NT[/TD]
[/TR]
[TR]
[TD="class: xl65"]Z3200[/TD]
[TD="class: xl65"]NT[/TD]
[/TR]
[TR]
[TD="class: xl65"]Z4020[/TD]
[TD="class: xl65"]NT[/TD]
[/TR]
[TR]
[TD="class: xl65"]Z4110[/TD]
[TD="class: xl65"]NT[/TD]
[/TR]
</tbody>[/TABLE]

=IF(E11<3000,"NT",((VLOOKUP(H11,List!$L$2:$M$12,2,"T"))))

 

[wideboydixon]

=IF(E11<3000,"NT",IFERROR(IF(MATCH(H11,List!$L$2:$L$12,0)>0,"NT","T"),"T"))

I think!!

WBD

 

[SB1976]

I've just done this too....and it seems to work!

Thank you too....

=IF(E7<3000,"NT",(IFERROR(VLOOKUP(H7,List!$L$2:$M$12,2,FALSE),"T")))