NFLnut
11-08-2011, 12:02 PM
I have a formula in Column O: =IF(J9>0,VLOOKUP(J9,Lookups!$B$32:$G$36,3))
I have a Data Validation (Drop Down) List in Column J. When nothing is selected in the corresponding cell in column J, the formula in the corresponding cell in column O (with the formula above) returns "FALSE." I need for it to return 0 (zero). I have tried adding ",0" to the end of that formula but it still returns FALSE. The contents of "Lookups!$B$32:$G$36,3" is 0, 40, 95, 95, 95 (column 3).
How do I get it to return zero?
I have a Data Validation (Drop Down) List in Column J. When nothing is selected in the corresponding cell in column J, the formula in the corresponding cell in column O (with the formula above) returns "FALSE." I need for it to return 0 (zero). I have tried adding ",0" to the end of that formula but it still returns FALSE. The contents of "Lookups!$B$32:$G$36,3" is 0, 40, 95, 95, 95 (column 3).
How do I get it to return zero?