Please help with Vlookup and If Statement

[crazysniper]

Hi All,

Can someone help me with this please.. Please see the attached file for what i am trying to accomplish.

I am not sure if this is possible with Vlookup. But here is what i want to do,

vlookup Item# from the left table and check if if whether the watt is >100, 100 to 149, 150 to 194 etc, if it is, then give me the code?

What i have in mind is this, =Vlookup(B4,G:G,IF(B4>100,H:H) but i am not sure if this is the right way of doing this that excel would understand.

If there is anyone out there, that can help, i would really appreciate it.

Thanks in advance.