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)
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" <[email protected]> wrote in message
news:[email protected]...
> 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))
"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)
On Thu, 7 Apr 2005 13:25:02 -0700, "Mark" <[email protected]>
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
You could also try . . .
=IF(ISERROR(VLOOKUP(A5,Group!$C$1251:$H$1287,6,0)),0, ISERROR(A5,Group!
$C$1251:$H$1287,6,0))
Which refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
Vs. just ISNA which refers to the #N/A (value not available) error value only.
-Fable
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks