Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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(...)) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOK UP | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
Need Help about vlook | Excel Worksheet Functions | |||
Vlook | Excel Worksheet Functions |