-
VLOOKUP Returning "FALSE" Instead Of Zero
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?
-
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)))
-
"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)))
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
Thank you. I made the change. The other came up with "0.00", so I thought all was good. This is better.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules