Using IF & VLOOKUP in one formula for value comparison (includes example workbook)

Table 1

Element Category 1 Category 2
Ac-227 540 16


Table 2 (on different worksheet)
Element Activity NTS Status
Ac-227 16 Category 2
Ac-227 15 Not NTS
Ac-227 550 Category 1

The above example is a simple example of what I am trying to do. I want to use vlookup and if/then statement so that in the column NTS Status, it will tell me if the element listed in Table 2 is Category 1, Category 2, or Not NTS, based on its activity value. So in the above example, Ac-227 is Category 1 if the value is greater than OR equal to 540, Category 2 if the value is greater than or equal to 16, and if below 16, I want it to say "Not NTS". I did attempt to create a formula but I definitely made some errors and forgot some things but here is the formula (based of my specific workbook and not the example I used):

PHP Code: 

=VLOOKUP(C3,'10CFR20_App_E_NTS'!A3:C22,1,FALSE))) 


I probably should've included some ">=" signs and maybe some other stuff, but hopefully this formula won't require too much editing to fix. Thanks for your help.

-HP RodNuclear

It would be easier to check and edit in the context of a sample workbook with some typical data.


Regards