Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
When using vlookup function on a long list of data, how do I replace a #N/A
result with the number 0? I am using the vlookup function on a cumulative list of data that is adding up annual results. Each year new names are added to the list and some do not come back (i.e. participate in 2006 but not in 2007). But have a cumulative list contains all participants. I want to have a 0 when someone does not a result for a year, not a #N/A - I can't sum up #N/A's. Please help! -- Tixpack |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
You can ignore #N/A in a sum formula like this:
=SUMIF(A:A,"<1E100") However, it's probably better to get rid of the #N/A altogether: =IF(ISNA(VLOOKUP(..........)),0,VLOOKUP(.......... )) -- Biff Microsoft Excel MVP "Tixpack" wrote in message ... When using vlookup function on a long list of data, how do I replace a #N/A result with the number 0? I am using the vlookup function on a cumulative list of data that is adding up annual results. Each year new names are added to the list and some do not come back (i.e. participate in 2006 but not in 2007). But have a cumulative list contains all participants. I want to have a 0 when someone does not a result for a year, not a #N/A - I can't sum up #N/A's. Please help! -- Tixpack |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |