I've got a butt ton of web page titles in column A that I need to match up with their URLS that currently reside in column D. In column C are the titles of all of those URLs. Column D currently contains thousands of URLs I don't need.
In an ideal world, I could use vlookup to simply match titles in column A to titles in column C and pull over the identified values from column D into column B. BUT the darn titles in column C aren't exactly the same as column A's, for some reason. They have some metadata garbage on the end of em. So they are NEARLY the same. I could work around this using the TRUE statement to conduct approximate matches, but many of the titles have the same first few words, so using the TRUE statement frequently returns an incorrect result.
Is there a way I can do a vlookup with combination of "First X words of the headline + "wildcard" OR, when using the TRUE statement, will give me all the possible options that I can choose from, instead of just dropping in the first one it finds?