Convert Snippet to Image

Preview:

'// Replacing #N/A with 0 in Excel using Formula.
'   =IFERROR (expression, value-if-error)

=IFERROR(VLOOKUP(2,2,1,FALSE),"0") 
' - Display value if no error 
' - Display 0 if error

'//Replace #N/A with blank
=IFERROR(VLOOKUP(2,2,1,FALSE),"")

Download PNG Download JPEG Download SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter