'VLOOKUP issue with Excel 2013 (getting #N/A)
I have successfully troubleshot VLOOKUP issues for years but this one has me stumped. I'm referencing between lists by full names (John Doe, for example) but getting #N/A. I've already tried TRIM (didn't change anything and by inspection I can see that there are no extra spaces in the original data anyway). I also tried Text-to-Columns, which in the past has magically fixed my VLOOKUPs but not now. I also tried a Stack Overflow suggestion to check each pair of names using the CODE function but both have the same numerical Code.
I've attached a sample file containing the issue.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|