replacing #N/A with 0

M

Mark

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

Mark

=IF(ISNA(VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)),0,VLOOKUP(A5,Group!$C$1251:$H$1287,6,0))

Regards

Trevor
 
D

Duke Carey

=IF(ISNA(VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)),0,VLOOKUP(A5,Group!$C$1251:$H$1287,6,0))
 
R

Ron Rosenfeld

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
 
Top