Need help with Vlookup not working

Hello,

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?

Thanks

Also posted here:

https://www.mrexcel.com/forum/…-working.html#post4882356

Re: Need help with Vlookup not working

Thanks for that, you just spotted the obvious thing I missed, No SJ- prefix in column A.

Sometime you just cant see for looking :?