Correcting a VLOOKUP

I am running a VLOOKUP but on some rows, instead of Zero I'm getting a blank. How can I correct this?

=VLOOKUP(A17,'[My Master List.xlsx]Sheet7'!$B$2:$Z$1111,20,FALSE)

I don't want a blank. Another formula relies on the zero.
Who is Participating?
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
That means in your lookup table, column U has a formula which returns a null string ("") and which in turn is returned by the VlookUp formula.
It would be better to fix your formula in column U in the lookup table to return 0 instead of a null string so that your VlookUp formula will also return a 0 instead of a null string.

Otherwise you can test for a null string like below...

=IF(VLOOKUP(A17,'[My Master List.xlsx]Sheet7'!$B$2:$Z$1111,20,FALSE)="",0,VLOOKUP(A17,'[My Master List.xlsx]Sheet7'!$B$2:$Z$1111,20,FALSE))

Open in new window

JohnAuthor Commented:
Thank you! You are correct, it was the other formula.
JohnAuthor Commented:
Thank you!
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome John!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.