G Guest Apr 7, 2005 #1 In Excell 2003 how would I write this formula to replace the #N/A with 0? Can it be done? =VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)
In Excell 2003 how would I write this formula to replace the #N/A with 0? Can it be done? =VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)
T Trevor Shuttleworth Apr 7, 2005 #2 Mark =IF(ISNA(VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)),0,VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)) Regards Trevor
Mark =IF(ISNA(VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)),0,VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)) Regards Trevor
G Guest Apr 7, 2005 #3 =IF(ISNA(VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)),0,VLOOKUP(A5,Group!$C$1251:$H$1287,6,0))
R Ron Rosenfeld Apr 7, 2005 #4 In Excell 2003 how would I write this formula to replace the #N/A with 0? Can it be done? =VLOOKUP(A5,Group!$C$1251:$H$1287,6,0) Click to expand... =IF(ISNA(VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)),0,VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)) or, a bit shorter: =IF(COUNTIF(Group!$C$1251:$C:1287,A5)=0,0,VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)) --ron
In Excell 2003 how would I write this formula to replace the #N/A with 0? Can it be done? =VLOOKUP(A5,Group!$C$1251:$H$1287,6,0) Click to expand... =IF(ISNA(VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)),0,VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)) or, a bit shorter: =IF(COUNTIF(Group!$C$1251:$C:1287,A5)=0,0,VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)) --ron
