Vlookup error - overtype text

  • Thread starter Thread starter Pritch14
  • Start date Start date
P

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
 
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
 
Back
Top