Friday, 6 April 2012

Remove #N/A errors - Excel

Overview   =IF(ISNA(lookup),0,lookup)  

#N/A errors are replaced with 0.
Example   =IF(ISNA(VLOOKUP(A1,D1:E5,2,0)),0,VLOOKUP(A1,D1:E5,2,0))
  

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)