Conditional format of a lookup result

[AussieExcelUser]

I use conditional formatting to hide "0" in reports in order to make them clearer to read. This works well apart from cells whose value is the result of a lookup where, if an error is found, the formula returns a "0":

=IF(ISERROR(VLOOKUP(A3,'UNC SOH'!E$6:F$2000,2,0)),"0",VLOOKUP(A3,'UNC SOH'!E$6:F$2000,2,0))

How can I get the conditional formula to work on what is actually showing in the cell? I have spent a lot of time trying all sorts of things and it is driving me nuts

[Bryan Hessey]

Try

=IF(ISERROR(VLOOKUP(A3,'UNC SOH'!E$6:F$2000,2,0)),0,VLOOKUP(A3,'UNC SOH'!E$6:F$2000,2,0))

---

I use conditional formatting to hide "0" in reports in order to make them clearer to read. This works well apart from cells whose value is the result of a lookup where, if an error is found, the formula returns a "0":

=IF(ISERROR(VLOOKUP(A3,'UNC SOH'!E$6:F$2000,2,0)),"0",VLOOKUP(A3,'UNC SOH'!E$6:F$2000,2,0))

How can I get the conditional formula to work on what is actually showing in the cell? I have spent a lot of time trying all sorts of things and it is driving me nuts

[AussieExcelUser]

D'oh - so simple and obvious! Your solution worked a treat!!

For the 2nd time this week, Bryan thanks so very much, you are indeed a champ