How do I display 0 instead of #NA after a vlookup

[Amz]

I have a formulae on excel using if & vlookup to find a value if a payment was taken on a certain date, the formulae is working, however I want to edit it so that instead of returning #NA if there isn't a result, it returns 0 - does anyone know how to edit it to do this? The formulae as it is currently is below:

=IF(F3=40379,VLOOKUP(A2,'Payments'!$A$2:$V$2495,7,FALSE),0)

 

[Andrew Poulsom]

Try:

=IF(F3=40379,IF(COUNTIF('Payments'!$A$2:$A$2495,A2),VLOOKUP(A2,'Payments'!$A$2:$V$2495,7,FALSE),0),0)

 

[Aladin Akyurek]

I have a formulae on excel using if & vlookup to find a value if a payment was taken on a certain date, the formulae is working, however I want to edit it so that instead of returning #NA if there isn't a result, it returns 0 - does anyone know how to edit it to do this? The formulae as it is currently is below:

=IF(F3=40379,VLOOKUP(A2,'Payments'!$A$2:$V$2495,7,FALSE),0)

Try one of...

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,
    IF(F3=40379,VLOOKUP(A2,'Payments'!$A$2:$V$2495,7,0),0)))

=IF(F3=40379,SUMIF('Payments'!$A$2:$A$2495,A2,'Payments'!$G$2:$G$2495),0)

 

[veldthui]

I have a formulae on excel using if & vlookup to find a value if a payment was taken on a certain date, the formulae is working, however I want to edit it so that instead of returning #NA if there isn't a result, it returns 0 - does anyone know how to edit it to do this? The formulae as it is currently is below:

=IF(F3=40379,VLOOKUP(A2,'Payments'!$A$2:$V$2495,7,FALSE),0)

Me I would use

=IF(F3=40379,IF(ISNA(VLOOKUP(A2,Payments!$A$2:$V$2495,7,FALSE)),0,VLOOKUP(A2,Payments!$A$2:$V$2495,7,FALSE)))