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?

vlookup with linked cell references
 

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?

vlookup with linked cell references
 

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?

vlookup with linked cell references
 

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?

vlookup with linked cell references
 

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?

vlookup with linked cell references
 

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?

vlookup with linked cell references
 

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?