Hi everyone -
I'm working on a project for my youth group and I'm a bit stumped. Hoping someone can help here.
I have 2 columns in the attached (look at the first tab).
I want to do a vlookup to match if one cell contains another. Because vlookup right now only looks at exact match, I need partial matches. I'm guessing a Macro would work since it's similar to your Ouija board because it breaks up the words.
So in this example I want to look at column B and then look at column E to find partial matches.
Example: B501 has "John Bosco" so does e27. So I want a "vlookup" of some sort on column C 501 to say "John Bosco" or return "cell 327"
As you can see the actual text of the two cells are different, but they have "John Bosco" in common.
I know this can get complicated but as long as 1 word matches another I'm okay with it because it saves me 80% of the time, and I can check the rest. The key is for it to show all the matches, not just one.
Vlookup has to match exactly and returns only 1 answer. I need it to match partially and return all the partial matches...
Any help would be appreciated