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?
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?