IF statement with vlookup nested

Hi,

I was hoping someone might be able to help me with a problem I've been having. I've attached a sample of the issue, as its work related i cant put the exact example but the principle is there.

On the sample table E1:F5 I have threshold values for each code. In column A I have codes, in column B I have values of these codes. I need column C to say either "Check" or "ok" depending on if the value of the code from Column A goes over the threshold from the table E2:F5.

I have tried to create a unique code to be greater then the unique code I've creating in column G

=IF((A2&B2)>(VLOOKUP(A2,$E$2:$G$5,3,0)),"Check","ok")

It appears that it is only picking up the first number on the lookup however because when the value goes beyond 2 digits it does not work correctly.

If anyone has any ideas could they help us out.


Thanks,


Lib