Hi. Im having problems with conditional formatting and cells with VLOOKUP. Here is my table. snip.JPG

I have two conditional formats on the cumulative column to turn cells red. The two formula are:
1) =AND(G44="Test",I44>2)
2) =AND(G44="sample",I44>5)

G = product description column
I = Cumulative column
44 = First row under the headers

This seems to work perfectly if I type the product description in manually into column G. However these are the product of a VLOOKUP formula and I can not get it to work. The VLOOKUP formula in the product description column is:
=IF(D44>0,(VLOOKUP(D44,standard,2)),0)

D= Code column
standard = 2nd sperate excell worksheet

Any help would be great.

Thanks