#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,)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/match across multiple columns? 16
Changing column reference for number of formulas at once 1
Calculating Costs for Each period 1
Lookup Across Multiple Rows / Columns 5
Filtering data 2
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Outlook macro 0
Setting original Formulas for copying 0

Top