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)