View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Changing n/a to zero

They look good to me. What doesn't work?
--
HTH,
Barb Reinhardt



"Sara" wrote:

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