Can someone please take a look at the attached file to see if you can figure out why the Vlookup in column C is not working? I've tried everything that I can think of like; they are both formatted the same, I've tried copying the data to a different spreadsheet, I've copied it to a text file and back again and I've tried TRIM and CLEAN to see if there was anything invisible that was stopping it from working but no success.
I've confirmed that the values are presnt in both columns for instance the value in A2 can be found in B1092 using Ctrl-F so, if Excel can find it that why, why cant the Vlookup find it?
Any ideas please?
Also posted here: