Prev: append multiple columns
Next: how do I get rid of ###### that appear instead of text in excel?
From: Dave Peterson on 31 Mar 2010 20:31
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
First  |  Prev  | 
Pages: 1 2
Prev: append multiple columns
Next: how do I get rid of ###### that appear instead of text in excel?