PDA

View Full Version : VLOOKUP Returning "FALSE" Instead Of Zero



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?

NFLnut
11-08-2011, 12:45 PM
Never mind .. I know I had tried something similar before, but it returned an error. I tried it again and got "0.00" (which is what I want).

For anyone else who has the same question in the future, I used this: =IF(J9=0,"0.00",IF(J9>0,VLOOKUP(J9,Lookups!$B$32:$G$36,3)))

mdmackillop
11-08-2011, 01:17 PM
"0.00" is a string, not 0
Try this and format the cell accordingly if you want 2 decimal places
=IF(J9=0,0,IF(J9>0,VLOOKUP(J9,Lookups!$B$32:$G$36,3)))

NFLnut
11-09-2011, 02:47 PM
Thank you. I made the change. The other came up with "0.00", so I thought all was good. This is better.