Spreadsheet: 787742d1657995629-lookup-and-provide-latest-price-for-month-based-criteria-lookup-match-issue_excel
Sheet: Comparison

 |  |  |  |  | ***WOULD LIKE TO GET THE PRICE FROM DATA SHEET (COLUMN K) IN THE BELOW TABLE - THE LATEST PRICE FOR THAT MONTH***
 |  |  |  | Years | Start Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month updated |  | PY | Pricing |  | Var
 |  |  |  | <1/1/2021 | 2021 |  |  |  |  |  |  |  |  |  | 2022 |  |  |  |  |  |  |  | 2021 | 2022 | 2021 | 2nd last | Latest
Country | Customer Name | Product Segment | Item Description |  | Jan | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Month | Month | Price | Price | Price | % change | Customer #
CA | OLD Reinhart - LaCr | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz |  |  |  |  |  |  | 16.71 |  |  |  |  |  |  |  |  |  |  | 18.56
CA | OLD Reinhart - LaCr | FCD | 70213002 - IMA Oatmeal Rsn 1oz |  |  |  |  |  |  | 27.47 |  |  |  |  |  |  |  |  |  |  | 30.84
CA | OLD Reinhart - LaCr | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 59.12 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | OLD Reinhart - LaCr | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 56.09999999999999 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | OLD Rein - Shaw | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz |  |  |  |  |  |  | 33.42 |  |  |  |  |  |  |  |  |  |  | 18.56
CA | OLD Rein - Shaw | FCD | 70213002 - IMA Oatmeal Rsn 1oz |  |  |  |  |  |  | 54.94 |  |  |  |  |  |  |  |  |  |  | 30.84
CA | OLD Rein - Shaw | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 59.12 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | OLD Rein - Shaw | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 56.09999999999999 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | PC | FCD | 70110434 - Wht Choc Mac 8lbx4 |  |  |  |  |  | 70.63000000000001 |  |  |  |  |  | 74.02 |  |  |  |  |  | 60.92
CA | QMCS | FCD | 7000962- Wht Choc Mac 3oz |  |  |  |  |  | 21.45 |  |  |  |  |  | 38.44 |  |  |  |  |  | 24.66
CA | QMCS | FCD | Flag 7000961 - Choc Chunk 3oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 22.85
CA | RDP Foodservice | FCD | 7000761 - Choc Chunk 1.5oz |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.3 |  | 20.76
CA | Rein FS | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz |  |  |  |  |  |  | 33.42 |  |  |  |  |  |  |  |  |  |  | 18.56
CA | Rein FS | FCD | 70213002 - IMA Oatmeal Rsn 1oz |  |  |  |  |  |  | 54.94 |  |  |  |  |  |  |  |  |  |  | 30.84
CA | Rein FS | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 59.12 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | Rein FS | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 56.09999999999999 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | Sy - DET | FCD | 7000110 - Oatmeal Rsn 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 29.22
CA | Sy - DET | FCD | 7000160 - Double Choc 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 29.22
CA | Sy - DET | FCD | Flag 70A0108 - Sugar 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 17.44
CA | Sy - GR | BCS | 7000612 - Choc Chunk Bkd 1.35oz |  |  |  |  |  | 18.05 |  |  |  |  |  |  |  |  |  |  |  | 17.44
USA | [NAME] |  | FG - Choc Chip TH Ns BnB 16.5oz 12.37LB US |  |  |  |  |  |  |  |  |  |  |  |  | 18.04 |  | 22.44 |  |  | 22.16
USA | [NAME] |  | FG Ns 16ozx12 Choc Chip Lovers BNB |  |  |  |  |  |  |  |  |  |  |  |  | 17.64 |  | 21.91 |  |  | 21.6