Please help with Vlookup and If Statement

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.

Perhaps first amend your title per forum rules?

Okay, I assume that Column G should be unique ID's and that you'd have a full table of codes in H4:L8 (for example).
In H2:L2, I put the minimum value for each catagory (i.e. 0,100, 150, 195, 204). Then you can use INDEX/MATCH to get results

In D4 copied down
=INDEX($H$4:$L$8,MATCH(B4,$G$4:$G$8,0),MATCH(C4,$H$2:$L$2))
Is that what you were looking for?

@Kevin. I think crazy meant H3 to be <100 not >100. That would make more sense