VLOOKUP Doesn

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 file A is "Acme Corporation Inc." in file B. And "Johnson & Johnson" in one file is "Johnson and Johnson" in the other. And "IBM" is "International Busine