vlookup with linked cell references

vlookup is returning incorrect information some of the time. The initial cell
it is looking up is a linked word. Is this what is causing the problem? If
so, can it be fixed?

Can you post your code?

"JAB" wrote:

> vlookup is returning incorrect information some of the time. The initial cell
> it is looking up is a linked word. Is this what is causing the problem? If
> so, can it be fixed?

The formula is:
vlookup(d2,'Summary Data'!$b$15:$c$45,2)

D2 is a cell that contains data that is linked from another sheet and is a
word, e.g. Finance, Corporate Admin.

The Summary Data sheet has the words typed in column B (and they match
exactly what is in the source document for D2), and an amount in column C.

I am not getting "N/A", I am getting incorrect results returned for the
majority, but not all, of the cells.

"Toppers" wrote:

> Can you post your code?
>
> "JAB" wrote:
>
> > vlookup is returning incorrect information some of the time. The initial cell
> > it is looking up is a linked word. Is this what is causing the problem? If
> > so, can it be fixed?

Is your Summary table sorted? the VLOOKUP function expects the table to be
sorted unless you add a final argument of FALSE or 0. If not sorted you'll
get incorrect results. If it IS sorted, change your formula to

=vlookup(d2,'Summary Data'!$b$15:$c$45,2,0)

and it will throw an #N/A error if the value in D2 isn't in the table. That
will allow you to figure out why you're getting the error



"JAB" wrote:

> The formula is:
> vlookup(d2,'Summary Data'!$b$15:$c$45,2)
>
> D2 is a cell that contains data that is linked from another sheet and is a
> word, e.g. Finance, Corporate Admin.
>
> The Summary Data sheet has the words typed in column B (and they match
> exactly what is in the source document for D2), and an amount in column C.
>
> I am not getting "N/A", I am getting incorrect results returned for the
> majority, but not all, of the cells.
>
> "Toppers" wrote:
>
> > Can you post your code?
> >
> > "JAB" wrote:
> >
> > > vlookup is returning incorrect information some of the time. The initial cell
> > > it is looking up is a linked word. Is this what is causing the problem? If
> > > so, can it be fixed?

Try:

=vlookup(d2,'Summary Data'!$b$15:$c$45,2,false)

This should give exact match.

"JAB" wrote:

> The formula is:
> vlookup(d2,'Summary Data'!$b$15:$c$45,2)
>
> D2 is a cell that contains data that is linked from another sheet and is a
> word, e.g. Finance, Corporate Admin.
>
> The Summary Data sheet has the words typed in column B (and they match
> exactly what is in the source document for D2), and an amount in column C.
>
> I am not getting "N/A", I am getting incorrect results returned for the
> majority, but not all, of the cells.
>
> "Toppers" wrote:
>
> > Can you post your code?
> >
> > "JAB" wrote:
> >
> > > vlookup is returning incorrect information some of the time. The initial cell
> > > it is looking up is a linked word. Is this what is causing the problem? If
> > > so, can it be fixed?

Problem Solved - I will use False in the future!

"Toppers" wrote:

> Try:
>
> =vlookup(d2,'Summary Data'!$b$15:$c$45,2,false)
>
> This should give exact match.
>
> "JAB" wrote:
>
> > The formula is:
> > vlookup(d2,'Summary Data'!$b$15:$c$45,2)
> >
> > D2 is a cell that contains data that is linked from another sheet and is a
> > word, e.g. Finance, Corporate Admin.
> >
> > The Summary Data sheet has the words typed in column B (and they match
> > exactly what is in the source document for D2), and an amount in column C.
> >
> > I am not getting "N/A", I am getting incorrect results returned for the
> > majority, but not all, of the cells.
> >
> > "Toppers" wrote:
> >
> > > Can you post your code?
> > >
> > > "JAB" wrote:
> > >
> > > > vlookup is returning incorrect information some of the time. The initial cell
> > > > it is looking up is a linked word. Is this what is causing the problem? If
> > > > so, can it be fixed?

Good news.

"JAB" wrote:

> Problem Solved - I will use False in the future!
>
> "Toppers" wrote:
>
> > Try:
> >
> > =vlookup(d2,'Summary Data'!$b$15:$c$45,2,false)
> >
> > This should give exact match.
> >
> > "JAB" wrote:
> >
> > > The formula is:
> > > vlookup(d2,'Summary Data'!$b$15:$c$45,2)
> > >
> > > D2 is a cell that contains data that is linked from another sheet and is a
> > > word, e.g. Finance, Corporate Admin.
> > >
> > > The Summary Data sheet has the words typed in column B (and they match
> > > exactly what is in the source document for D2), and an amount in column C.
> > >
> > > I am not getting "N/A", I am getting incorrect results returned for the
> > > majority, but not all, of the cells.
> > >
> > > "Toppers" wrote:
> > >
> > > > Can you post your code?
> > > >
> > > > "JAB" wrote:
> > > >
> > > > > vlookup is returning incorrect information some of the time. The initial cell
> > > > > it is looking up is a linked word. Is this what is causing the problem? If
> > > > > so, can it be fixed?