Try
=IF(ISNA(VLOOKUP(G3,A:D,4,FALSE)),0,VLOOKUP(G3,A:D ,4,FALSE))

--
Jacob


"Jaleel" wrote:

Hi,

=VLOOKUP(G3,A:D,4,FALSE)

When I put the above formula, if the lookup_value is not available in the
table_array #N/A appears in the result. How can I modify the formula to get
the result as 0 instead of #N/A?

Can anybody help?

Jaleel