hi

I have two columns of names of people. I am wanting to do a partial value look up. i.e. if Column a has "A J Smith" it links to a "Alan Smith" in column B

Sorry trying to think of a clearer way to explain this but strruggling

thanks

R