#value on some cells only

[dilyanyordanov]

Hi guys, I am doing a report for work and I used vlookup for some of the cells to go find information from other sheets. The problem is with a particular person's name only... excel gives me #value on specific cells only. Others work fine.... All data type is either general or number. I tried and changed it but nothing... I copied one of the sheets from another person which everything was calculated ok...but still the same problem occurs. Any suggestions ?

 

[Rick Rothstein]

My bet is that the 7th character is a non-breaking space (ASCII 160) that might have been picked up by copying a value from the web somewhere along the line. Does this work...

=SUBSTITUTE(G20,CHAR(160),"")*E20