Try:
=IF(F3=40379,IF(COUNTIF('Payments'!$A$2:$A$2495,A2),VLOOKUP(A2,'Payments'!$A$2:$V$2495,7,FALSE),0),0)
This is a discussion on How do I display 0 instead of #NA after a vlookup within the Excel Questions forums, part of the Question Forums category; I have a formulae on excel using if & vlookup to find a value if a payment was taken on ...
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:
=IF(F3=40379,IF(COUNTIF('Payments'!$A$2:$A$2495,A2),VLOOKUP(A2,'Payments'!$A$2:$V$2495,7,FALSE),0),0)
Microsoft MVP - Excel
Assuming too much and qualifying too much are two faces of the same problem.
Like this thread? Share it with others