Spreadsheet: 787745d1657996955-lookup-and-provide-latest-price-for-month-based-criteria-lookup-match-issue_excel
Sheet: data

Country | Customer No | Customer Name | Customer Price Group | Item No | Item Description | Product Segment | [NAME] | Currency | UoM | Unit Price | Start Date | End Date
CA | C00372 | Sy - GR | 3SYSGRANDR | 102780 | 7000612 - Choc Chunk Bkd 1.35oz | BCS | X1 | USD | CS | 17.44 | 2022-07-01 00:00:00
CA | C00372 | Sy - GR | 3SYSGRANDR | 102780 | 7000612 - Choc Chunk Bkd 1.35oz | BCS | X2 | USD | CS | 18.05 | 2021-07-01 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102844 | 70213201 - IMA Choc Chip Bulk Bkd 2oz | BCS | X3 | USD | CS | 16.71 | 2021-08-01 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102844 | 70213201 - IMA Choc Chip Bulk Bkd 2oz | BCS | X4 | USD | CS | 16.71 | 2021-08-31 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102844 | 70213201 - IMA Choc Chip Bulk Bkd 2oz | BCS | X5 | USD | CS | 18.56 | 2022-07-01 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102844 | 70213201 - IMA Choc Chip Bulk Bkd 2oz | BCS | X6 | USD | CS | 16.71 | 2021-08-01 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102844 | 70213201 - IMA Choc Chip Bulk Bkd 2oz | BCS | X7 | USD | CS | 16.71 | 2021-08-31 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102844 | 70213201 - IMA Choc Chip Bulk Bkd 2oz | BCS | X8 | USD | CS | 18.56 | 2022-07-01 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102844 | 70213201 - IMA Choc Chip Bulk Bkd 2oz | BCS | X9 | USD | CS | 16.71 | 2021-08-01 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102844 | 70213201 - IMA Choc Chip Bulk Bkd 2oz | BCS | X10 | USD | CS | 16.71 | 2021-08-31 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102844 | 70213201 - IMA Choc Chip Bulk Bkd 2oz | BCS | X11 | USD | CS | 18.56 | 2022-07-01 00:00:00
CA | C00364 | Sy - DET | 3SYSDETROI | 102432 | 7000110 - Oatmeal Rsn 2oz | FCD | X12 | USD | CS | 29.22 | 2022-07-01 00:00:00
CA | C00364 | Sy - DET | 3SYSDETROI | 102432 | 7000110 - Oatmeal Rsn 2oz | FCD | X13 | USD | CS | 34.64 | 2021-07-01 00:00:00 | 2021-12-31 00:00:00
CA | C00364 | Sy - DET | 3SYSDETROI | 102432 | 7000110 - Oatmeal Rsn 2oz | FCD | X14 | USD | CS | 36.3 | 2022-01-01 00:00:00
CA | C00364 | Sy - DET | 3SYSDETROI | 102436 | 7000160 - Double Choc 2oz | FCD | X15 | USD | CS | 29.22 | 2022-07-01 00:00:00
CA | C00364 | Sy - DET | 3SYSDETROI | 102436 | 7000160 - Double Choc 2oz | FCD | X16 | USD | CS | 34.64 | 2021-07-01 00:00:00 | 2021-12-31 00:00:00
CA | C00364 | Sy - DET | 3SYSDETROI | 102436 | 7000160 - Double Choc 2oz | FCD | X17 | USD | CS | 36.3 | 2022-01-01 00:00:00
CA | C00364 | Sy - DET | 3SYSDETROI | 102635 | Flag 70A0108 - Sugar 2oz | FCD | X18 | USD | CS | 17.44 | 2022-07-01 00:00:00
CA | C00364 | Sy - DET | 3SYSDETROI | 102635 | Flag 70A0108 - Sugar 2oz | FCD | X19 | USD | CS | 34.64 | 2021-07-01 00:00:00 | 2021-12-31 00:00:00
CA | C00364 | Sy - DET | 3SYSDETROI | 102635 | Flag 70A0108 - Sugar 2oz | FCD | X20 | USD | CS | 36.3 | 2022-01-01 00:00:00
CA | [NAME] | RDP Foodservice | 3RDP | 101880 | 7000761 - Choc Chunk 1.5oz | FCD | X21 | USD | CS | 20.76 | 2022-07-01 00:00:00
CA | [NAME] | RDP Foodservice | 3RDP | 101880 | 7000761 - Choc Chunk 1.5oz | FCD | X22 | USD | CS | 36.3 | 2022-05-10 00:00:00
CA | C00436 | PC | 3PETERSON | 101908 | 70110434 - Wht Choc Mac 8lbx4 | FCD | X23 | USD | CS | 60.92 | 2022-07-01 00:00:00
CA | C00436 | PC | 3PETERSON | 101908 | 70110434 - Wht Choc Mac 8lbx4 | FCD | X24 | USD | CS | 70.63000000000001 | 2021-07-01 00:00:00 | 2021-12-31 00:00:00
CA | C00436 | PC | 3PETERSON | 101908 | 70110434 - Wht Choc Mac 8lbx4 | FCD | X25 | USD | CS | 74.02 | 2022-01-01 00:00:00
CA | C01082 | QMCS | 3CULINARY | 102507 | Flag 7000961 - Choc Chunk 3oz | FCD | [NAME] | USD | CS | 22.85 | 2022-07-01 00:00:00
CA | C01082 | QMCS | 3CULINARY | 102507 | Flag 7000961 - Choc Chunk 3oz | FCD | X27 | USD | CS | 34.64 | 2021-07-01 00:00:00 | 2021-12-31 00:00:00
CA | C01082 | QMCS | 3CULINARY | 102507 | Flag 7000961 - Choc Chunk 3oz | FCD | X28 | USD | CS | 36.3 | 2022-01-01 00:00:00
CA | C01082 | QMCS | 3CULINARY | 102508 | 7000962- Wht Choc Mac 3oz | FCD | X29 | USD | CS | 21.45 | 2021-07-01 00:00:00 | 2021-12-31 00:00:00
CA | C01082 | QMCS | 3CULINARY | 102508 | 7000962- Wht Choc Mac 3oz | FCD | X30 | USD | CS | 24.66 | 2022-07-01 00:00:00
CA | C01082 | QMCS | 3CULINARY | 102508 | 7000962- Wht Choc Mac 3oz | FCD | X31 | USD | CS | 38.44 | 2022-01-01 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102598 | 70213002 - IMA Oatmeal Rsn 1oz | FCD | X32 | USD | CS | 27.47 | 2021-08-01 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102598 | 70213002 - IMA Oatmeal Rsn 1oz | FCD | X33 | USD | CS | 27.47 | 2021-08-31 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102598 | 70213002 - IMA Oatmeal Rsn 1oz | FCD | X34 | USD | CS | 30.84 | 2022-07-01 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102599 | 70213003 - IMA Peanut Btr 1oz | FCD | X35 | USD | CS | 29.56 | 2021-08-01 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102599 | 70213003 - IMA Peanut Btr 1oz | FCD | X36 | USD | CS | 29.56 | 2021-08-31 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102599 | 70213003 - IMA Peanut Btr 1oz | FCD | X37 | USD | CS | 33.13 | 2022-07-01 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102606 | 70213027 - IMA Double Choc 1.5oz | FCD | X38 | USD | CS | 28.05 | 2021-08-01 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102606 | 70213027 - IMA Double Choc 1.5oz | FCD | X39 | USD | CS | 28.05 | 2021-08-31 00:00:00
CA | C01113 | OLD Rein - Shaw | 3REILCSODL | 102606 | 70213027 - IMA Double Choc 1.5oz | FCD | X40 | USD | CS | 31.7 | 2022-07-01 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102598 | 70213002 - IMA Oatmeal Rsn 1oz | FCD | X41 | USD | CS | 27.47 | 2021-08-01 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102598 | 70213002 - IMA Oatmeal Rsn 1oz | FCD | X42 | USD | CS | 27.47 | 2021-08-31 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102598 | 70213002 - IMA Oatmeal Rsn 1oz | FCD | X43 | USD | CS | 30.84 | 2022-07-01 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102599 | 70213003 - IMA Peanut Btr 1oz | FCD | X44 | USD | CS | 29.56 | 2021-08-01 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102599 | 70213003 - IMA Peanut Btr 1oz | FCD | X45 | USD | CS | 29.56 | 2021-08-31 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102599 | 70213003 - IMA Peanut Btr 1oz | FCD | X46 | USD | CS | 33.13 | 2022-07-01 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102606 | 70213027 - IMA Double Choc 1.5oz | FCD | X47 | USD | CS | 28.05 | 2021-08-01 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102606 | 70213027 - IMA Double Choc 1.5oz | FCD | X48 | USD | CS | 28.05 | 2021-08-31 00:00:00
CA | C01133 | OLD Reinhart - LaCr | 3REILCSODL | 102606 | 70213027 - IMA Double Choc 1.5oz | FCD | X49 | USD | CS | 31.7 | 2022-07-01 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102598 | 70213002 - IMA Oatmeal Rsn 1oz | FCD | X50 | USD | CS | 27.47 | 2021-08-01 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102598 | 70213002 - IMA Oatmeal Rsn 1oz | FCD | X51 | USD | CS | 27.47 | 2021-08-31 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102598 | 70213002 - IMA Oatmeal Rsn 1oz | FCD | X52 | USD | CS | 30.84 | 2022-07-01 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102599 | 70213003 - IMA Peanut Btr 1oz | FCD | X53 | USD | CS | 29.56 | 2021-08-01 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102599 | 70213003 - IMA Peanut Btr 1oz | FCD | X54 | USD | CS | 29.56 | 2021-08-31 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102599 | 70213003 - IMA Peanut Btr 1oz | FCD | X55 | USD | CS | 33.13 | 2022-07-01 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102606 | 70213027 - IMA Double Choc 1.5oz | FCD | X56 | USD | CS | 28.05 | 2021-08-01 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102606 | 70213027 - IMA Double Choc 1.5oz | FCD | X57 | USD | CS | 28.05 | 2021-08-31 00:00:00
CA | C01221 | Rein FS | 3REILCSODL | 102606 | 70213027 - IMA Double Choc 1.5oz | FCD | X58 | USD | CS | 31.7 | 2022-07-01 00:00:00
USA | U00022 | [NAME] | 3NESTLE | 104517 | FG - Choc Chip TH Ns BnB 16.5oz 12.37LB US |  | X59 | USD | CS | 18.04 | 2022-02-16 00:00:00 | 2022-03-31 00:00:00
USA | U00022 | [NAME] | 3NESTLE | 104517 | FG - Choc Chip TH Ns BnB 16.5oz 12.37LB US |  | X60 | USD | CS | 22.16 | 2022-07-01 00:00:00
USA | U00022 | [NAME] | 3NESTLE | 104517 | FG - Choc Chip TH Ns BnB 16.5oz 12.37LB US |  | X61 | USD | CS | 22.44 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00
USA | U00022 | [NAME] | 3NESTLE | 104638 | FG Ns 16ozx12 Choc Chip Lovers BNB |  | X62 | USD | CS | 17.64 | 2022-02-16 00:00:00 | 2022-03-31 00:00:00
USA | U00022 | [NAME] | 3NESTLE | 104638 | FG Ns 16ozx12 Choc Chip Lovers BNB |  | X63 | USD | CS | 21.6 | 2022-07-01 00:00:00
USA | U00022 | [NAME] | 3NESTLE | 104638 | FG Ns 16ozx12 Choc Chip Lovers BNB |  | X64 | USD | CS | 21.91 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00