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
Bookmarks