Do I use conditional formating?
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 |
Do I use conditional formating?
=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 |
All times are GMT +1. The time now is 03:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com