Something like:

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

--
Gary''s Student - gsnu201001


"Emece" wrote:

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.-