Changing n/a to zero
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!
--
Sara
|