Need formula to match names

Ok I think I can help you with this.

We will need to create a macro to check each entry in list a against list b.

I have tested the formula to that I would use on the attached extract.

if you can send me dummies of list A and b so that I can see the formats

Then I will create something for you.

Thank you but company policy doesn't allow transfer of files across the internet. Any chance you could paste the VBA code? I'll try it out and let you know if it works. Thanks!!