View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Match or VLOOKUP

You might have extra spaces in some of the descriptions - as you can't
see these the entries might look the same, but to Excel they are not.
You can apply the TRIM( ) function to both sets of descriptions in a
helper column to get rid of extra spaces and then fix the values with
paste special, and copy them back over the original entries. This
should improve things for you.

Hope this helps.

Pete