Changing n/a to zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Excel 2000 & have followed previous thread suggestions of:

=IF(ISNA(VLOOKUP(F14,IntWE4Oct,2,FALSE),0,VLOOKUP(F14,IntWE4Oct,2,FALSE"))

and

=IF(ISNA(VLOOKUP(F14,IntWE4Oct,2,FALSE)"",VLOOKUP(F14,IntWE4Oct,2,FALSE"))

and neither work for me - HELP!
 
No it wasn't that, I finally managed to work it out it's:
=IF(ISNA(VLOOKUP(F14,IntWE4Oct,2,FALSE)),0,VLOOKUP(F14,IntWE4Oct,2,"FALSE"))
 
As a matter of interest, why the text string "FALSE" as the final argument
for the second VLOOKUP, instead of the Boolean FALSE which you had as the
final argument for the first VLOOKUP?
Your original formulae did, of course, have mismatched parentheses which you
have now corrected.
 
Back
Top