Replace #N/A with 0

Emece · Mar 30, 2010

When I use the vLookup formula and the result is #N/A, I need to replace this
with a 0, is this possible in only one formula?

Thanks in advance

Regards
Emece.-

Gary''s Student · Mar 30, 2010

Something like:

=IF(ISNA(VLOOKUP(A1,B1:B2,2)),0,VLOOKUP(A1,B1:B2,2))

Replace #N/A with 0

Emece

Gary''s Student