View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default To show 0 instead #Value!

VLOOKUP might be returning #VALUE
ISNA only checks for #N/A error... Use ISERROR if you want to suppress
#VALUE errors too...



"user" wrote:

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