ExcelBanter - replacing #N/A with 0

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - replacing #N/A with 0 (https://www.excelbanter.com/excel-discussion-misc-queries/21043-replacing-n-0-a.html)

Mark

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)

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

"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)

Duke Carey

=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)

Ron Rosenfeld

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

All times are GMT +1. The time now is 01:11 AM.