Spreadsheet: 468621d1467389621-index-match-issue-example-3-
Sheet: Sheet2

 |  |  |  |  |  | Net Sell Price | Net Sales  Profit | Net Sales  Margin% | Cost | Order quantity | No of order lines | INDEX/MATCH | VLOOKUP
Sold-to party |  | [NAME] (MD) | Local manufact (MD) | Product hierarchy (MD) |  | $ | $ | % | $ | PC |  | Header
31000007 | ELEANOR L MAYNARD | DELL | [NAME] | 001001750003004300 | [NAME] | 334.44 | 0.04 | 0.0119602918311207 | 438 | 2 | 2
31000101 | WILL CHEN | DELL | [NAME] | 001001750003000600 | DELL CHROMEBOOK NOTEBOOKS | 166.84 | 0 | 0 | 278.07 | 1 | 1
31000145 | [NAME] | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 338.8 | 0 | 0 | 668.67 | 1 | 1
31000340 | RICARDO GOMEZ | DELL | [NAME] | 001001750003004300 | [NAME] | 112.7 | 0 | 0 | 161 | 1 | 1
31000674 | [NAME] | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 544.75 | 0.11 | 0.0201927489674162 | 1089.4 | 1 | 1
31000692 | PAUL FUNKE | DELL | [NAME] | 001001750003004300 | [NAME] | 87.61 | 0.01 | 0.0114142221207625 | 146 | 1 | 1
31001872 | [NAME] | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 898.42 | 0.15 | 0.016695977382516 | 1497.26 | 1 | 1
31001964 | [NAME] | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 377.48 | 0.06 | 0.0158948818480449 | 622.17 | 1 | 1
31002300 | [NAME] SHIFRIN | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 376.08 | 0.06 | 0.0159540523292916 | 622.17 | 1 | 1
31002386 | [NAME] | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 0 | -6.86 | 0 | 17.14 | 0 | 0
31002525 | AMANDA LEE | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 520.77 | 0.07 | 0.0134416345027555 | 705.87 | 1 | 1
31002535 | FRANTZ BENJAMIN | DELL | [NAME] | 001001750003004300 | [NAME] | 232.04 | 0.04 | 0.0172384071711774 | 322 | 2 | 2
31002676 | [NAME] | DELL | [NAME] | 001001750003004300 | [NAME] | 128.82 | 0 | 0 | 161.02 | 1 | 1
31003135 | BLAKE DONNELLY | DELL | [NAME] | 001001750003004300 | [NAME] | 259.2 | 0 | 0 | 450 | 1 | 1
31003271 | BRAD DEBARDELABEN | DELL | [NAME] | 001001750003000600 | DELL CHROMEBOOK NOTEBOOKS | 308.88 | 0 | 0 | 386.1 | 1 | 1
31003347 | [NAME] | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 510.32 | 0.08 | 0.0156764383132152 | 840 | 1 | 1
31003404 | KEVIN SPRING | DELL | [NAME] | 001001750003004300 | [NAME] | 584.07 | 0.07 | 0.011984864827846 | 730 | 1 | 1
31003427 | [NAME] | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 434.8 | 0.06 | 0.0137994480220791 | 573.43 | 1 | 1
31003560 | [NAME] | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 416.31 | 0.05 | 0.0120102808003651 | 520.32 | 1 | 1
31003562 | NICHOLAS LOSEE | DELL | [NAME] | 001001750003004300 | [NAME] | 934.48 | 0.12 | 0.0128413663213766 | 1168 | 4 | 3
31003590 | [NAME] A NEUMEIER | DELL | [NAME] | 001001750003004300 | [NAME] | 81.61 | 0.01 | 0.0122534003185884 | 102 | 1 | 1
31003610 | ANDY FERNANDEZ | DELL | [NAME] | 001001750003004300 | [NAME] | 467.26 | 0.06 | 0.0128408166759406 | 584 | 2 | 1
31003625 | CINDY SMITH | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 458.69 | 0.07 | 0.0152608515555168 | 687.27 | 1 | 1
 |  |  | [NAME] | 001001750003004300 | [NAME] | 152.02 | 0.02 | 0.013156163662676 | 190 | 1 | 1
31003724 | FRASER WRIGHT | DELL | DELL NOTEBOOKS | 001001750005001600 | DELL LATITUDE NOTEBOOKS | 357.67 | 0.04 | 0.0111834931640898 | 447.04 | 1 | 1
31003745 | [NAME] | DELL | [NAME] | 001001750003004300 | [NAME] | 211.22 | 0.02 | 0.00946880030300161 | 264 | 2 | 1
38000002 | A TECH COMPUTER SERV | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 768.49 | 15.21 | 1.97920597535427 | 796.28 | 1 | 1
 |  | SONICWALL | SONICWALL ENT LICENSE | 001003600013000100 | SONICWALL ENT LICENSE 10% OFF | 4567.63 | 251.63 | 5.50898387128555 | 4316 | 1 | 1
 |  |  | SONICWALL HARDWARE | 001003600013000500 | SONICWALL NON-ENT HW 25% OFF | 800.79 | 23.62 | 2.94958728255847 | 814.87 | 1 | 1
 |  |  |  | 001003600013002600 | SONICWALL TZ HW 25% OFF | 717.91 | 21.53 | 2.99898315944896 | 730.16 | 1 | 1
 |  |  | SONICWALL WARRANTY & SVC | 001003600013000900 | SONICWALL NON-ENT LICENSE 25% OFF | 1483.82 | 58.61 | 3.94994001967894 | 1495 | 2 | 2
 |  |  |  | 001003600013002700 | SONICWALL TZ  LICENSE 25% OFF | 258.2 | 10.2 | 3.95042602633617 | 248 | 1 | 1
38000022 | SCI INC DBA / A&C COMPUTE | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 1199.01 | 21 | 1.75144494207721 | 1448.01 | 3 | 1
 |  | SONICWALL | SONICWALL WARRANTY & SVC | 001003600013000900 | SONICWALL NON-ENT LICENSE 25% OFF | 37.74 | 1.49 | 3.9480657127716 | 38 | 1 | 1
38000026 | AMERICAN MICRO GROUP | DELL | DELL PRINTER ACCESSORIES | 001001750005000000 | DELL PRINTER ACCESSORIES | 126.57 | 8.76 | 6.92107134392036 | 117.81 | 1 | 1
38000030 | INFO SYSTEMS INC. | DELL | DELL DESKTOPS | 001001750003001200 | DELL OPTIPLEX DESKTOPS | 526.81 | 6.48 | 1.2300449877565 | 520.33 | 1 | 1