View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Natasha
 
Posts: n/a
Default #N/A instead of 0 when doing a VLOOKUP

I am using a VLOOKUP and everything is fine except when the result is 0, it
gives a #N/A instead of a 0. How do I get rid of the #N/A when doing a , I
want want the result to be 0.