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)
=IF(F3=40379,VLOOKUP(A2,'Payments'!$A$2:$V$2495,7,FALSE),0)