#n/a problems

K

Kat

Hi all

The sum below does a search for a number, finds it and all works well, if
the number is not there it reads #N/A and causes problems is there any way i
can get this cell to read 0



=INDEX('E Mails'!$F$601:$F$700,MATCH(D632,'E Mails'!$C$601:$C$700,))
 
C

charlie

Try =IF(ISNA(INDEX('E Mails'!$F$601:$F$700,MATCH(D632,'E
Mails'!$C$601:$C$700,))), 0, INDEX('E
Mails'!$F$601:$F$700,MATCH(D632,'E Mails'!$C$601:$C$700,)))
 
Top