I am struggling to figure this out. I want to pull some data, dropping account $ amounts into Sheet2 from Sheet1. But if the account is inactive,(and therefore not on the Sheet1) I would like it to come back with just a $0 instead of the #N/A

I know I can do this with an IF statement, I just cannot figure it out!

Right now my Vlookup is =vlookup(A3,'Sheet1'!$a$2:$d$1068,3,false)

So I know that is correct, but how do I put this into the IF statement to say that if A3 is not in Sheet1 = 0

=IF(ISNA(VLOOKUP(A3,Sheet1!$A$2:$D$1068,3,FALSE)), 0, VLOOKUP(A3,Sheet1!$A$2:$D$1068,3,FALSE))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thank you!

Ask Your Question

Weekly Poll