VLOOKUP returns 0 (zero) when lookup cell is blank
 

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.

VLOOKUP returns 0 (zero) when lookup cell is blank
 

You should test for blanks:

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

--
Gary''s Student - gsnu201001


"C.T." wrote:

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.

VLOOKUP returns 0 (zero) when lookup cell is blank
 

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

"Gary''s Student" wrote:

You should test for blanks:

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

--
Gary''s Student - gsnu201001


"C.T." wrote:

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.

VLOOKUP returns 0 (zero) when lookup cell is blank
 

Your formula points at column 12 of the property2 range.

C.T. wrote:

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

"Gary''s Student" wrote:

You should test for blanks:

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

--
Gary''s Student - gsnu201001


"C.T." wrote:

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.

--

Dave Peterson

VLOOKUP returns 0 (zero) when lookup cell is blank
 

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

"Dave Peterson" wrote:

Your formula points at column 12 of the property2 range.

C.T. wrote:

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

"Gary''s Student" wrote:

You should test for blanks:

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

--
Gary''s Student - gsnu201001


"C.T." wrote:

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.

--

Dave Peterson
.

VLOOKUP returns 0 (zero) when lookup cell is blank
 

So you had a typo in your question?

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

What is being returned incorrectly?

What's in A10?

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

C.T. wrote:

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

"Dave Peterson" wrote:

Your formula points at column 12 of the property2 range.

C.T. wrote:

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

"Gary''s Student" wrote:

You should test for blanks:

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

--
Gary''s Student - gsnu201001


"C.T." wrote:

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.

--

Dave Peterson
.


--

Dave Peterson