If you've ever tried to match two spreadsheets together, you know this pain. You've got a list of 5,000 company names in one file and 8,000 in another. You need to find the overlaps. So you write a VLOOKUP formula, hit enter, and watch as it returns #N/A for about 60% of your data.

Not because the matches dont exist. But because "Acme Corp" in...