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