Prev: append multiple columns
Next: how do I get rid of ###### that appear instead of text in excel?
From: C.T. C.T. on 31 Mar 2010 13:15
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.
From: Gary''s Student on 31 Mar 2010 13:29
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.
From: C.T. on 31 Mar 2010 13:55
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.
From: Dave Peterson on 31 Mar 2010 17:36
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
From: C.T. on 31 Mar 2010 20:08
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
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: append multiple columns
Next: how do I get rid of ###### that appear instead of text in excel?