Solved IF statement with Vlookup - get rid of #N/A

October 27, 2011 at 12:53:41
Specs: Windows XP
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


See More: IF statement with Vlookup - get rid of #N/A

Report •

#1
October 27, 2011 at 13:04:41
✔ Best Answer
=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.


Report •

#2
October 27, 2011 at 13:08:54
Thank you!

Report •
Related Solutions


Ask Question