Vlookup error - overtype text

[Pritch14]

I have two sheets of data and I want to add the totals for accoun
numbers to a summary sheet.

Vlookup returns as #N/a but when I go to the source data and overtyp
it with the exact same words/numbers then it works. The source dat
has been cut and pasted from another sheet which had subtotals

 

[Allan]

Sometimes the format of one cell is different than the
format of another o r there may be extraneous characters
(spaces...) in one cell that doesn't exist in the other.
A quick way to convert the lookup list by using the =trim
() function. Insert a cloumn next to the column you are
using as a lookup, insert the =trim() function in the new
column next to the cell you wish to correct. Copy the
formula down. You may not notice a difference between the
two cells. Copy and Paste Special / Value the range from
the new colum to the old. Try the lookup now.

Allan