vlookup not matching seemingly identical columns

[cpit]

Hi,can anyone help with the following problem:
when I run vlookup to search for, say, Burnside High School, Excel is returning a value for Burnahm High School. When I use "false" I get #n/a, but Burnside High School is in both columns! I have tried clearing the format, copying all and pasting values only - same result, BUT when I copy the cell from 1 column to the next, I get the correct value! Any ideas?

 

[Damon Ostrander]

Hi cpit,

My guess is that there is an extra blank character in Burnside High School somewhere, most likely at the beginning or end of the string or possibly double blanks between the words.

Damon