One way:

=IF(ISNA(MATCH(A1,J:J,FALSE)),"Not found",VLOOKUP(A1,J:K,2,FALSE))

In article ,
"CochranConsult" wrote:

When using Vlookup and there is no direct match the response is "#N/A",
telling me that there is no value in the lookup table. The problem is that I
have to sum the results of the lookup function. Since some of the values are
"#N/A" the sum of the column is "#N/A". How can I easily replace the "#N/A"
with either text or a "0" so that the sum formula for the column produces an
answer?