software

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?

quot;JABquot; wrote:

gt; vlookup is returning incorrect information some of the time. The initial cell
gt; it is looking up is a linked word. Is this what is causing the problem? If
gt; 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 quot;N/Aquot;, I am getting incorrect results returned for the
majority, but not all, of the cells.

quot;Toppersquot; wrote:

gt; Can you post your code?
gt;
gt; quot;JABquot; wrote:
gt;
gt; gt; vlookup is returning incorrect information some of the time. The initial cell
gt; gt; it is looking up is a linked word. Is this what is causing the problem? If
gt; gt; 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
quot;JABquot; wrote:

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

Try:

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

This should give exact match.

quot;JABquot; wrote:

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

Problem Solved - I will use False in the future!

quot;Toppersquot; wrote:

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

Good news.

quot;JABquot; wrote:

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