View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cathy Cathy is offline
external usenet poster
 
Posts: 104
Default vlookup repl #/NA with 0

using vlookup i want anytime a #/na is returned to be replaced with 0. I
haven't had any luck with nesting commands to get this acomplished.
thanks