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?