View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sara sara is offline
external usenet poster
 
Posts: 82
Default 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