I am using this formula in column C

=IFERROR(VLOOKUP(B2,'NewData'!A:V,11,FALSE),"NA")

I am using this formula in column D

=IF(C2<=100,"1",IF(C2>300,"3",IF(C2>100,"2","NA")))

It is failing to recognize the NA results and instead showing 3 as the result.

What have I got wrong? Thank you.