Spreadsheet: 849005d1699569878-vlookup-v-xlookup-match-and-highlight-v3-
Sheet: Sheet2

ALL Account Search Name |  |  | SPECIAL Account Search Name |  |  |  | DESIRED RESULT (MATCHING ACCOUNT NAMES) | Pull Column F | Pull Column C
LIBERTY ENERGY GAINESVILLE CAN | ALL1A6I7I | 1000 | LOS LEASING COMPANY MIDLA MIDLAND CAN | ALL1A5M31 | 4378.1 |  |  | 4378.1
MISC SALES FOR AREA 609 CAN | ALL999609 | 1145.28 | NATURAL GAS FUEL SYSTEMS LL ROANOKE CAN | ALLL37136 | 5521.01 |  | NATURAL GAS FUEL SYSTEMS LL ROANOKE CAN | 5521.01
LOS LEASING COMPANY MIDLA MIDLAND CAN | ALL1A5M31 | 1290.56 | MISC SALES FOR AREA 609 CAN | ALL999609 | 6663.92 |  | MISC SALES FOR AREA 609 CAN | 6663.92
NATURAL GAS FUEL SYSTEMS LL ROANOKE CAN | ALLL37136 | 1435.84 | LIBERTY OILFIELD SERVICE SHREVEPORTCAN | ALL1A5M0D | 7806.830000000001 |  | LIBERTY OILFIELD SERVICE SHREVEPORTCAN | 7806.830000000001
RIVERSIDE ENGINEERING SAN ANTONIO CAN | [NAME] | 1581.12 |  | ALL1A3NZ2 | 8949.740000000002 |  |  | 8949.740000000002
[NAME] CAN | ALL440853 | 1726.4 | LOS LEASING COMPANY LLC [NAME] CAN | ALL1A5RB0 | 10092.65 |  | LOS LEASING COMPANY LLC [NAME] CAN | 10092.65
TIGE BOATS INC ABILENE CAN | ALLN07429 | 1871.68 | MAXXIM INDUSTRIES MIDLAND CAN | ALL1A6AMN | 11235.56 |  | MAXXIM INDUSTRIES MIDLAND CAN | 11235.56
GRANUTECH SATURN SYST GRAND PRAIRIE CAN | ALL375512 | 2016.96 | SUN ENERGY SERVICES LLC D MIDLAND CAN | ALL1A19UG | 12378.47 |  | SUN ENERGY SERVICES LLC D MIDLAND CAN | 12378.47
LIBERTY OILFIELD SERVICE SHREVEPORTCAN | ALL1A5M0D | 2162.24 | STEP ENERGY SERVICES USA MIDLAND CAN | ALLM67692 | 13521.38 |  | STEP ENERGY SERVICES USA MIDLAND CAN | 13521.38
 | ALL1A3NZ2 | 2307.52 | CONSOLIDATED RIG WORKS FT WORTH CAN | ALL206592 | 14664.29 |  | CONSOLIDATED RIG WORKS FT WORTH CAN | 14664.29
LOS LEASING COMPANY LLC [NAME] CAN | ALL1A5RB0 | 2452.8 | TOTAL EQUIP SRV GRANBURY CAN | ALL899693 | 15807.2 |  | TOTAL EQUIP SRV GRANBURY CAN | 15807.2
HELMERICH PAYNE INC HOUSTON CAN | ALL413508 | 2598.08 | PROFRAC MANUFACTURING LONGVIEW CAN | ALL1A5NHR | 16950.11 |  | PROFRAC MANUFACTURING LONGVIEW CAN | 16950.11
MAXXIM INDUSTRIES MIDLAND CAN | ALL1A6AMN | 2743.36 | GRANUTECH SATURN SYST GRAND PRAIRIE CAN | ALL375512 | 18093.02 |  | GRANUTECH SATURN SYST GRAND PRAIRIE CAN | 18093.02
MI SHER FLEET SPECIALIST PONDER CAN | ALL592233 | 2888.64 | [NAME] CAN | ALL1A1KMN | 19235.93 |  | [NAME] CAN | 19235.93
GERDAU AMERISTEEL MIDLOTHIAN CAN | ALL360557 | 3033.92 | APPLIED ENERGY COMPANY LLC SACHSE CAN | [NAME] | 20378.84 |  | GERDAU AMERISTEEL MIDLOTHIAN CAN | 24950.48
NU ENERGY BENBROOK CAN | ALLK53186 | 3179.2 | WHITMORE MANUFACTURING ROCKWALL CAN | ALL971003 | 21521.75 |  | HELMERICH PAYNE INC HOUSTON CAN | 26093.39
TOTAL EQUIP SRV GRANBURY CAN | ALL899693 | 3324.48 | PRO PETRO SERV MIDLAND CAN | ALLK15946 | 22664.66 |  | RIVERSIDE ENGINEERING SAN ANTONIO CAN | 30665.03
STEP ENERGY SERVICES USA MIDLAND CAN | ALLM67692 | 3469.76 | CUDD PUMPING SERVICE ODESSA CAN | ALL226470 | 23807.57 |  | THREE TEK GRAND PRAIRIE CAN | 31807.94
SUN ENERGY SERVICES LLC D MIDLAND CAN | ALL1A19UG | 3615.04 | GERDAU AMERISTEEL MIDLOTHIAN CAN | ALL360557 | 24950.48 |  | PROFRAC 401 CISCO CAN | 35236.67000000001
PROFRAC 401 CISCO CAN | ALLL98330 | 3760.32 | HELMERICH PAYNE INC HOUSTON CAN | ALL413508 | 26093.39 |  | MI SHER FLEET SPECIALIST PONDER CAN | 37522.49
WATSON INCORPORATED FORT WORTH CAN | ALL954407 | 3905.6 | MISC SALES FOR AREA 252CAN | ALL999252 | 27236.3
CEMCO INC OLNEY CAN | [NAME] | 4050.88 | WEYERHAEUSER CO SIMSBOROCAN | ALL967595 | 28379.21
WARRIOR RIG TECHN SPRINGTOWN CAN | [NAME] | 4196.16 | PROFRAC HOLDINGS LLC ALEDO CAN | ALL1A7AFD | 29522.12
CONSOLIDATED RIG WORKS FT WORTH CAN | ALL206592 | 4341.44 | RIVERSIDE ENGINEERING SAN ANTONIO CAN | [NAME] | 30665.03
[NAME] CAN | ALL1A1KMN | 4486.72 | THREE TEK GRAND PRAIRIE CAN | ALL1A3JKK | 31807.94
INTEGRITY CONTROL SERVIC RICHARDSON CAN | ALL1A0F7H | 4632 | RAM PRODUCTS LTD RICHLAND HILLS CAN | ALL747991 | 32950.85000000001
PROFRAC MANUFACTURING LONGVIEW CAN | ALL1A5NHR | 4777.28 | CUDD PRESSURE CNTL ODESSA CAN | ALL226408 | 34093.76
BRIGHT CO OP INC NACOGDOCHES CAN | ALL124709 | 4922.56 | PROFRAC 401 CISCO CAN | ALLL98330 | 35236.67000000001
THREE TEK GRAND PRAIRIE CAN | ALL1A3JKK | 5067.84 | [NAME] | ALL1A7I8V | 36379.58
F T S INTERNATIONAL MFG ALEDO CAN | ALLK41116 | 5213.12 | MI SHER FLEET SPECIALIST PONDER CAN | ALL592233 | 37522.49
DTR299 CATERPILLAR INC R29 WACO CAN | ALL1A4BSC | 5358.4 | VICTORY CLIMATE SYSTEMS FORT WORTH CAN | ALLD00557 | 38665.4
ECKEL MFG ODESSA CAN | ALL278711 | 5503.68 | LONESTAR USA SAFETY AND T MIDLAND CAN | ALL1A68YM | 39808.31
WAGNER SMITH CO BURLESTON CAN | ALL946710 | 5648.96 | MISC SALES FOR AREA 605 CAN | ALL999605 | 40951.22
INTERTECH FLUID POWER GRAPEVINE CAN | ALL463569 | 5794.24 | NATIONAL CARWASH SOL B M G IRVING CAN | ALLM76706 | 42094.13