=IF(VLOOKUP(A7,'[UNION WAGE SHEET.xls]UT Job
List'!$A$1:$K$324,4,FALSE)A1,VLOOKUP(A7,'[UNION WAGE SHEET.xls]UT Job
List'!$A$1:$K$324,4,FALSE),0)

replace A1 with the "other cell"

"Pakmount" wrote:

I am using a vlookup formula
=VLOOKUP(A7,'[UNION WAGE SHEET.xls]UT Job List'!$A$1:$K$324,4,FALSE)
to get a value in another worksheet.
If i want to add a conditional format (and i am not sure if that is what i
need to add)
so that if this cell is less than another cell, it gives me a zero value,
what do i need to add to this formula?
Thanks