Need help with Vlookup not working

[vba_monkey]

Hello,

I've posted this question on Ozgrid because I cant upload my file to this site and screen shots dont help in this instance:

Need help with Vlookup not working

The question is:

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?

If you could take a look, I'd greatly appreciate it.

Thanks

 

[mrhstn]

It looks like all the values in column B are prefixed. Find would work because column B cell might contain the value from column A.

Try a wildcard

=ISNUMBER(MATCH("*"&A2, B:B, 0))

 

[vba_monkey]

Thanks for that, sometimes you stare so hard at a spreadsheet, you cant see the obvious.

You think you know everything and then show everyone else you're a fool