I want my #N/A to be replaced by 0..?

Question

How could i replace the output instead of #N/A, it must be 0?? or any other numerals because excel cannot compute the #N/A

Answer 1

Use IF and ISNA or ISERROR

say if you use Match function or those lookup function and it can't find the value, it return #N/A, to make it show result if not #N/A, show 0 if yes it's an #N/A, try this

=IF(ISNA( Match(value, range, 0)), 0, Match(value, range, 0))

To make cell blank if #N/A

=IF(ISERROR( Vlookup(value, range, column, false)), "", Vlookup(value, range, column, false))

Hope this helps.