I am comparing lists (Fortune 500 with other similar lists S&P 500, Dow Jones, etc.). The problem I am running into is that in each of the lists, the names of companies are slightly off (Amazon vs. Amazon.com or Toyota vs Toyota Company...) I am trying to use vlookup to first see if the companies are in the same rows, and than I am using an IF function to make another column that has conditional formatting which will say "YES" which is also highlighted in green, if the names are in the same list. As mentioned above however, the names are slightly off which has made me have to go back and check to make sure the names are exactly the same from one list to anohter. Any help on how to get around this problem would be amazingly appreciated, as this job is very tedious and time consuming. I have fairly basic knowledge of excel, which barely any knowledge of macros. Thanks.