vlookup with linked cell references

J

JAB

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?
 
J

JAB

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.
 
D

Duke Carey

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
 
Top