VLOOKUP returns 0 (zero) when lookup cell is blank

C

C.T.

I have two columns of data that I vlookup to. They both contain text,
numbers and some blank cells. Column 1 returns blanks correctly but column 2
returns 0.

Is it a formatting issue?

Any help is appreciated.
 
G

Gary''s Student

You should test for blanks:

=IF(VLOOKUP(3,A1:B3,2,FALSE)="","",VLOOKUP(3,A1:B3,2,FALSE))
 
C

C.T.

Is there a reason why my column 1 data is returning blank correctly but not
from column 2?

Here is my equation:

=VLOOKUP(A10, property2, 12, FALSE)

Thanks!
CT
 
C

C.T.

My data is reference through a defined name = property2. Column 12 is the
column that is pulling in the 0 data.
 
D

Dave Peterson

So you had a typo in your question?

What is being returned incorrectly?

What's in A10?

I think you're going to have to share some more details.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP returning a value when it shouldn't 2
VLOOKUP returns 0 (zero) when lookup cell is blank 5
Macro that sorts data with blanks at the bottom 1
VLOOKUP returning #N/A ?? 3
Same forumula returns both 0 & N/A 2
Return BLANK is cell value sought is blank 13
VLookup or Macro? 0
Query returns blank cells where there should be data 1

Top