Spreadsheet: 155682d1337008433-vlookup-or-indexmatch-on-closest-name-match-company-lists_match
Sheet: Fortune 500

 |  | Rank | Company | Revenues | Profits
 |  |  |  | ($ millions) | ($ millions)
 |  | 1 | Wal-Mart Stores | 421849 | 16389
 |  | 2 | Exxon Mobil | 354674 | 30460
 |  | 3 | Chevron | 196337 | 19024
 |  | 4 | ConocoPhillips | 184966 | 11358
 |  | 5 | Fannie Mae | 153825 | -14014
 |  | 6 | General Electric | 151628 | 11644
 |  | 7 | [NAME] | 136185 | 12967
 |  | 8 | General Motors | 135592 | 6172
 |  | 9 | Bank of America Corp. | 134194 | -2238
 |  | 10 | Ford Motor | 128954 | 6561
 |  | 11 | Hewlett-Packard | 126033 | 8761
 |  | 12 | AT&T | 124629 | 19864
 |  | 13 | J.P. Morgan Chase & Co. | 115475 | 17370
 |  | 14 | Citigroup | 111055 | 10602
 |  | 15 | [NAME] | 108702 | 1263
 |  | 16 | Verizon Communications | 106565 | 2549
 |  | 17 | American International Group | 104417 | 7786
 |  | 18 | International Business Machines | 99870 | 14833
 |  | 19 | Cardinal Health | 98601.9 | 642.2
 |  | 20 | Freddie Mac | 98368 | -14025
 |  | 21 | CVS Caremark | 96413 | 3427
 |  | 22 | UnitedHealth Group | 94155 | 4634
 |  | 23 | Wells Fargo | 93249 | 12362
 |  | 24 | [NAME] | 86034 | 324
 |  | 25 | Kroger | 82189.4 | 1116.3
 |  | 26 | Procter & Gamble | 79689 | 12736
 |  | 27 | AmerisourceBergen | 77954 | 636.7
 |  | 28 | [NAME] | 77946 | 1303
 |  | 29 | Marathon Oil | 68413 | 2568
 |  | 30 | Home Depot | 67997 | 3338
 |  | 31 | Pfizer | 67809 | 8257
 |  | 32 | Walgreen | 67420 | 2091
 |  | 33 | Target | 67390 | 2920
 |  | 34 | Medco Health Solutions | 65968.3 | 1427.3
 |  | 35 | Apple | 65225 | 14013
 |  | 36 | Boeing | 64306 | 3307
 |  | 37 | State Farm Insurance Cos. | 63176.7 | 1762.8
 |  | 38 | Microsoft | 62484 | 18760
 |  | 39 | [NAME] | 61682 | 1930
 |  | 40 | Johnson & Johnson | 61587 | 13334
 |  | 41 | Dell | 61494 | 2635
 |  | 42 | WellPoint | 58801.8 | 2887.1
 |  | 43 | PepsiCo | 57838 | 6320
 |  | 44 | United Technologies | 54326 | 4373
 |  | 45 | Dow Chemical | 53674 | 2310
 |  | 46 | MetLife | 52717 | 2790
 |  | 47 | Best Buy | 49694 | 1317
 |  | 48 | United Parcel Service | 49545 | 3488
 |  | 49 | Kraft Foods | 49542 | 4114
 |  | 50 | [NAME]'s | 48815 | 2010
 |  | 51 | INTL FCStone | 46940.3 | 5.4
 |  | 52 | Lockheed Martin | 46890 | 2926
 |  | 53 | Merck | 45987 | 861
 |  | 54 | Goldman Sachs Group | 45967 | 8354
 |  | 55 | Express Scripts | 44989.7 | 1181.2
 |  | 56 | Intel | 43623 | 11464
 |  | 57 | Sears Holdings | 43326 | 133
 |  | 58 | Caterpillar | 42588 | 2700
 |  | 59 | Chrysler Group | 41946 | -652
 |  | 60 | Safeway | 41050 | 589.8
 |  | 61 | Supervalu | 40597 | 393
 |  | 62 | Cisco Systems | 40040 | 7767
 |  | 63 | Morgan Stanley | 39320 | 4703
 |  | 64 | Prudential Financial | 38414 | 3195
 |  | 65 | Walt Disney | 38063 | 3963
 |  | 66 | Comcast | 37937 | 3635
 |  | 67 | Sysco | 37243.5 | 1180
 |  | 68 | Sunoco | 35453 | 234
 |  | 69 | Abbott Laboratories | 35166.7 | 4626.2
 |  | 70 | Coca-Cola | 35119 | 11809
 |  | 71 | New York Life Insurance | 34947.2 | 1091.5
 |  | 72 | Northrop Grumman | 34757 | 2053
 |  | 73 | FedEx | 34734 | 1184
 |  | 74 | [NAME] | 34613 | 2125
 |  | 75 | Ingram Micro | 34589 | 318.1
 |  | 76 | [NAME] | 34305 | 1491
 |  | 77 | Aetna | 34246 | 1766.8
 |  | 78 | Amazon.com | 34204 | 1152
 |  | 79 | Humana | 33868.2 | 1099.4
 |  | 80 | Enterprise Products Partners | 33739.3 | 320.8
 |  | 81 | Honeywell International | 33370 | 2022
 |  | 82 | Liberty Mutual Insurance Group | 33193 | 1678
 |  | 83 | News Corp. | 32778 | 2539
 |  | 84 | DuPont | 32733 | 3031
 |  | 85 | Sprint Nextel | 32563 | -3465
 |  | 86 | General Dynamics | 32466 | 2624
 |  | 87 | TIAA-CREF | 32224.9 | 1405.9
 |  | 88 | Delta Air Lines | 31755 | 593
 |  | 89 | Allstate | 31400 | 928
 |  | 90 | HCA Holdings | 30683 | 1207
 |  | 91 | American Express | 30242 | 4057
 |  | 92 | Google | 29321 | 8505
 |  | 93 | Tyson Foods | 28430 | 780
 |  | 94 | Philip Morris International | 27208 | 7259
 |  | 95 | Time Warner | 26888 | 2578
 |  | 96 | Oracle | 26820 | 6135
 |  | 97 | 3M | 26662 | 4085
 |  | 98 | Deere | 26004.6 | 1865
 |  | 99 | Plains All American Pipeline | 25893 | 505
 |  | 100 | Rite Aid | 25669.1 | -506.7