Home |
Search |
Today's Posts |
#1
|
|||
|
|||
replacing #N/A with 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) |
#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" wrote in message ... 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) |
#3
|
|||
|
|||
=IF(ISNA(VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)),0, VLOOKUP(A5,Group!$C$1251:$H$1287,6,0))
"Mark" wrote: 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) |
#4
|
|||
|
|||
On Thu, 7 Apr 2005 13:25:02 -0700, "Mark"
wrote: 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) =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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding and Replacing a "?" | Excel Discussion (Misc queries) | |||
replacing TRUE/FALSE | New Users to Excel | |||
replacing TRUE/FALSE | New Users to Excel | |||
replacing just the sheet names within formulas | Excel Worksheet Functions | |||
Replacing a number with a description in Excel | Excel Worksheet Functions |