Spreadsheet: 468594d1467379014-index-match-issue-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Product Hierarchy Description | PM | [NAME] | Product Hierarchy | Header
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001001750003006700 | DELL CLOUD CLIENT COMPUTING | [NAME] TEIXEIRA X83306 | DELL | DELL CLOUD CLIENT COMPUTING | Wyse
 |  |  |  |  |  |  | Net Sell Price | Net Sales  Profit | Net Sales  Margin% | Cost | Order quantity | No of order lines |  |  |  |  |  |  | 001001750003004800 | DELL POWEREDGE SERVER CONTINUUM BTS CTS | [NAME] TEIXEIRA X83306 | DELL | [NAME] | ESG
 | Sold-to party |  | [NAME] (MD) | Local manufact (MD) | Product hierarchy (MD) |  | $ | $ | % | $ | PC |  | Header |  |  |  |  |  | 001001750003004400 | [NAME] SERVERS | [NAME] TEIXEIRA X83306 | DELL | [NAME] | ESG
 | 31000007 | ELEANOR L MAYNARD | DELL | [NAME] | 001001750003004300 | [NAME] | 334.44 | 0.04 | 0.0119602918311207 | 438 | 2 | 2 |  |  |  |  |  |  | 001001750003003200 | [NAME] POWEREDGE SERVERS | [NAME] TEIXEIRA X83306 | DELL | [NAME] | ESG
 | 31000101 | WILL CHEN | DELL | [NAME] | 001001750003000600 | DELL CHROMEBOOK NOTEBOOKS | 166.84 | 0 | 0 | 278.07 | 1 | 1 |  |  |  |  |  |  | 001001750003003300 | DELL POWERVAULT STORAGE | [NAME] TEIXEIRA X83306 | DELL | DELL STORAGE | ESG
 | 31000145 | [NAME] | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 338.8 | 0 | 0 | 668.67 | 1 | 1 |  |  |  |  |  |  | 001001750003005000 | DELL STORAGE CTO -NO RETURNS | [NAME] TEIXEIRA X83306 | DELL | DELL STORAGE CTO | ESG
 | 31000340 | RICARDO GOMEZ | DELL | [NAME] | 001001750003004300 | [NAME] | 112.7 | 0 | 0 | 161 | 1 | 1 |  |  |  |  |  |  | 001001750003003400 | DELL POWERCONNECT SWITCH | [NAME] TEIXEIRA X83306 | DELL | DELL SWITCHES | ESG
 | 31000674 | [NAME] | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 544.75 | 0.11 | 0.0201927489674162 | 1089.4 | 1 | 1 |  |  |  |  |  |  | 001001750003005100 | DELL SWITCHES CTO -NO RETURNS | [NAME] TEIXEIRA X83306 | DELL | DELL SWITCHES CTO | ESG
 | 31000692 | PAUL FUNKE | DELL | [NAME] | 001001750003004300 | [NAME] | 87.61 | 0.01 | 0.0114142221207625 | 146 | 1 | 1 |  |  |  |  |  |  | 001001750003000600 | DELL CHROMEBOOK NOTEBOOKS | [NAME] X76206 | DELL | [NAME] | Client
 | 31001872 | [NAME] | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 898.42 | 0.15 | 0.016695977382516 | 1497.26 | 1 | 1 |  |  |  |  |  |  | 001001750003000800 | DELL CHROMEBOX DESKTOPS | [NAME] X76206 | DELL | [NAME] | Client
 | 31001964 | [NAME] | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 377.48 | 0.06 | 0.0158948818480449 | 622.17 | 1 | 1 |  |  |  |  |  |  | 001001750005002700 | [NAME] | [NAME] X76206 | DELL | [NAME] | Client
 | 31002300 | [NAME] SHIFRIN | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 376.08 | 0.06 | 0.0159540523292916 | 622.17 | 1 | 1 |  |  |  |  |  |  | 001001750003002300 | [NAME] NOTEBOOKS | [NAME] X76206 | DELL | [NAME] | Client
 | 31002386 | [NAME] | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 0 | -6.86 | 0 | 17.14 | 0 | 0 |  |  |  |  |  |  | 001001750005002900 | [NAME] PRINTERS | [NAME] X76206 | DELL | [NAME] PRINTERS | Client
 | 31002525 | AMANDA LEE | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 520.77 | 0.07 | 0.0134416345027555 | 705.87 | 1 | 1 |  |  |  |  |  |  | 001001750003001200 | DELL OPTIPLEX DESKTOPS | [NAME] X76206 | DELL | DELL DESKTOPS | Client
 | 31002535 | FRANTZ BENJAMIN | DELL | [NAME] | 001001750003004300 | [NAME] | 232.04 | 0.04 | 0.0172384071711774 | 322 | 2 | 2 |  |  |  |  |  |  | 001001750005001700 | DELL LATITUDE NOTEBOOKS CTO | [NAME] X76206 | DELL | DELL LATITUDE NOTEBOOKS CTO | Client
 | 31002676 | [NAME] | DELL | [NAME] | 001001750003004300 | [NAME] | 128.82 | 0 | 0 | 161.02 | 1 | 1 |  |  |  |  |  |  | 001001750005000800 | [NAME] NOTEBOOKS CTO | [NAME] X76206 | DELL | DELL LATITUDE NOTEBOOKS CTO | Client
 | 31003135 | BLAKE DONNELLY | DELL | [NAME] | 001001750003004300 | [NAME] | 259.2 | 0 | 0 | 450 | 1 | 1 |  |  |  |  |  |  | 001001750003004300 | [NAME] | [NAME] X76206 | DELL | [NAME] | Client
 | 31003271 | BRAD DEBARDELABEN | DELL | [NAME] | 001001750003000600 | DELL CHROMEBOOK NOTEBOOKS | 308.88 | 0 | 0 | 386.1 | 1 | 1 |  |  |  |  |  |  | 001001750003001900 | [NAME] | [NAME] X76206 | DELL | [NAME] | Client
 | 31003347 | [NAME] | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 510.32 | 0.08 | 0.0156764383132152 | 840 | 1 | 1 |  |  |  |  |  |  | 001001750005001600 | DELL LATITUDE NOTEBOOKS | [NAME] X76206 | DELL | DELL NOTEBOOKS | Client
 | 31003404 | KEVIN SPRING | DELL | [NAME] | 001001750003004300 | [NAME] | 584.07 | 0.07 | 0.011984864827846 | 730 | 1 | 1 |  |  |  |  |  |  | 001001750005000900 | [NAME] RUGGED NOTEBOOKS | [NAME] X76206 | DELL | DELL NOTEBOOKS | Client
 | 31003427 | [NAME] | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 434.8 | 0.06 | 0.0137994480220791 | 573.43 | 1 | 1 |  |  |  |  |  |  | 001001750005000700 | DELL XPS NOTEBOOKS | [NAME] X76206 | DELL | DELL NOTEBOOKS | Client
 | 31003560 | [NAME] | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 416.31 | 0.05 | 0.0120102808003651 | 520.32 | 1 | 1 |  |  |  |  |  |  | 001001750003001100 | DELL OPTIPLEX DESKTOPS CTO | [NAME] X76206 | DELL | DELL OPTIPLEX DESKTOPS CTO | Client
 | 31003562 | NICHOLAS LOSEE | DELL | [NAME] | 001001750003004300 | [NAME] | 934.48 | 0.12 | 0.0128413663213766 | 1168 | 4 | 3 |  |  |  |  |  |  | 001001750005001300 | DELL PRECISION FIXED WS CTO | [NAME] X76206 | DELL | DELL PRECISION DESKTOPS CTO | Client
 | 31003590 | [NAME] A NEUMEIER | DELL | [NAME] | 001001750003004300 | [NAME] | 81.61 | 0.01 | 0.0122534003185884 | 102 | 1 | 1 |  |  |  |  |  |  | 001001750005001500 | DELL PRECISION MOBILE WS CTO | [NAME] X76206 | DELL | DELL PRECISION NOTEBOOK CTO | Client
 | 31003610 | ANDY FERNANDEZ | DELL | [NAME] | 001001750003004300 | [NAME] | 467.26 | 0.06 | 0.0128408166759406 | 584 | 2 | 1 |  |  |  |  |  |  | 001001750005000100 | [NAME] PRINTERS | [NAME] X76206 | DELL | DELL PRINTERS | Client
 | 31003625 | CINDY SMITH | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 458.69 | 0.07 | 0.0152608515555168 | 687.27 | 1 | 1 |  |  |  |  |  |  | 001001750005000200 | [NAME] | [NAME] X76206 | DELL | [NAME] | Client
 |  |  |  | [NAME] | 001001750003004300 | [NAME] | 152.02 | 0.02 | 0.013156163662676 | 190 | 1 | 1 |  |  |  |  |  |  | 001001750003005800 | [NAME] | [NAME] X76206 | DELL | [NAME] | Client
 | 31003724 | FRASER WRIGHT | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 357.67 | 0.04 | 0.0111834931640898 | 447.04 | 1 | 1 |  |  |  |  |  |  | 001001750005001000 | [NAME] RUGGED NOTEBOOKS CTO | [NAME] X76206 | DELL | [NAME] | Client
 | 31003745 | [NAME] | DELL | [NAME] | 001001750003004300 | [NAME] | 211.22 | 0.02 | 0.00946880030300161 | 264 | 2 | 1 |  |  |  |  |  |  | 001001750005000500 | DELL VENUE TABLETS | [NAME] X76206 | DELL | DELL TABLETS | Client
 | 38000002 | A TECH COMPUTER SERV | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 768.49 | 15.21 | 1.97920597535427 | 796.28 | 1 | 1 |  |  |  |  |  |  | 001001750005001200 | DELL VENUE TABLETS CTO | [NAME] X76206 | DELL | DELL VENUE CTO | Client
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001001750005002400 | DELL VOSTRO DESKTOPS | [NAME] X76206 | DELL | DELL VOSTRO | Client
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001001750005002500 | DELL VOSTRO DESKTOPS CTO | [NAME] X76206 | DELL | DELL VOSTRO | Client
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001001750003002400 | DELL VOSTRO NOTEBOOKS | [NAME] X76206 | DELL | DELL VOSTRO | Client
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001001750005000600 | DELL PRECISION FIXED WS | [NAME] X76206 | DELL | DELL WORKSTATIONS | Client
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001001750005001400 | DELL PRECISION MOBILE WS | [NAME] X76206 | DELL | DELL WORKSTATIONS | Client
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001001750005002200 | OBSOLETE | [NAME] X76206 | DELL | DELL DESKTOPS | Client
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001001750005002300 | OBSOLETE | [NAME] X76206 | DELL | DELL DESKTOPS | Client
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001001750005003000 | DELL POWEREDGE S&P ACCESSORIES | [NAME] TEIXEIRA X83306 | DELL | [NAME] | ESG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013000000 | SONICWALL ENT HW 10% OFF | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL ENT HARDWARE | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013000100 | SONICWALL ENT LICENSE 10% OFF | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL ENT LICENSE | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013000300 | SONICWALL HIGH AVAIL NON-ENT HW 25% OFF | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL HARDWARE | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013000500 | SONICWALL NON-ENT HW 25% OFF | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL HARDWARE | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013002600 | SONICWALL TZ HW 25% OFF | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL HARDWARE | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013002100 | SONICWALL NFR ENT HW 10% OFF | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL NOT FOR RESALE | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013002200 | SONICWALL NFR ENT LICENSING 10% OFF | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL NOT FOR RESALE | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013000800 | SONICWALL NFR GEN4 HW 25% NE | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL NOT FOR RESALE | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013001900 | SONICWALL NFR NON-ENT LICENSING 25% OFF | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL NOT FOR RESALE | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013000900 | SONICWALL NON-ENT LICENSE 25% OFF | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL WARRANTY & SVC | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013002300 | SONICWALL TRAINING SVC NO DISCOUNT | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL WARRANTY & SVC | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001003600013002700 | SONICWALL TZ  LICENSE 25% OFF | [NAME] TEIXEIRA X83306 | SONICWALL | SONICWALL WARRANTY & SVC | SonicWALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001004180013000000 | WYSE SOFTWARE | [NAME] TEIXEIRA X83306 | WYSE | WYSE SOFTWARE | Wyse
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001004180013000300 | WYSE STREAMING MGR TIER 1 | [NAME] TEIXEIRA X83306 | WYSE | WYSE STREAMING MGR | Wyse
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001004180013000400 | WYSE STREAMING MGR TIER 2 | [NAME] TEIXEIRA X83306 | WYSE | WYSE STREAMING MGR | Wyse
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001004180013000800 | WYSE WINDOW TERMINALS TIER 1 | [NAME] TEIXEIRA X83306 | WYSE | WYSE THIN CLIENTS | Wyse
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001004180013000600 | WYSE WINDOW TERMINALS TIER 2 | [NAME] TEIXEIRA X83306 | WYSE | WYSE THIN CLIENTS | Wyse