|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