View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
user user is offline
external usenet poster
 
Posts: 44
Default To show 0 instead #Value!

Hello

I am trying to do a vlookup using if(isNa... and if isn't not found, I want
it to show a zero instead of #VAlue!. Not sure why #Value is showing up, as
opposed to the #N/A.
--
Thanks