VLOOKUP / Conditional Formatting - How to Apply if Results = 0

[mlbdc2012]

I have a VLOOKUP Formula that spits out a value that is then conditionally formatted based on the result of the value. This works great to a name that has a value to lookup, but what about a name that doesn't have a value to lookup?

My VLOOKUP formula = =IFERROR(VLOOKUP(C13,'Draft Board'!C:I,7,0),"0")

My Conditional format = =DN13>0

I have 10 names on Sheet 2 in my workbook, 8 of which are on Sheet 1. How do I get the remaining two names that aren't on Sheet 1 but still have a VLOOKUP formula attached to them to apply to the conditional format rules. Their value in the VLOOKUP is showing zero because their value comes back with an error but I formatted that in my formula to = 0 so shouldn't the conditional format ignore those two names because it should only conditionally format if the value is greater than zero?

Thanks!

[Brendan_Floyde]

Remove the ""

i.e.

Please Login or Register  to view this content.

not

Please Login or Register  to view this content.

[FDibbins]

Just to add into what Brendan said...
When you use "" to enclose a value, you convert it to text - and excel then (generally) will not recognise it as a number. Having said that, excel considers and text to have a value higher than any value...so A will be higher than 50 etc

[mlbdc2012]

Remove the ""

i.e.

Please Login or Register  to view this content.

not

Please Login or Register  to view this content.

Perfect thanks!

[mlbdc2012]

Just to add into what Brendan said...
When you use "" to enclose a value, you convert it to text - and excel then (generally) will not recognise it as a number. Having said that, excel considers and text to have a value higher than any value...so A will be higher than 50 etc

Great thanks for the heads up!

[FDibbins]

Happy to help, thanks for the feedback