ONe way:

=IF(ISNA(MATCH(A1, J:J, FALSE)), "", VOOKUP(A1, J:K, 2, FALSE))

In article ,
Hong wrote:

Hello,
My vlookup returns the value #N/A, but I am using the value for other
culculation.
If the vlookup value returns to #N/A, then all my final result is #N/A.

How can I change the #N/A into "0" or blank, so it doesn't affect my final
result.

Thank you in advance.