Vlook up value is #N/A
 

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.

Vlook up value is #N/A
 

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.

Vlook up value is #N/A
 

=IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...))

Where (...) is your vlookup formula.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


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

Vlook up value is #N/A
 

Note that ISERROR() will also ignore errors like #VALUE!, #REF!, etc.
which may not be desirable.

In general it's better to keep error trapping as narrow as possible, in
this case:

=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...))




In article ,
Luke M wrote:

=IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...))

Vlook up value is #N/A
 

Hi,

2003:
=IF(ISNA(VLOOKUP(A1,C1:D10,2,)),"",VLOOKUP(A1,C1:D 10,2,))

in 2007:
=IFERROR(VLOOKUP(A1,C1:D10,2,),"")

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Hong" wrote in message
...
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.