Spreadsheet: 267671d1380135472-two-criteria-lookup-with-two-seporate-criteria-making-a-unique-identifier-excel-lookup-help
Sheet: Sheet1

TABLE A |  |  |  |  | Table B
Date | Product ID | Product | [NAME] |  |  | Product Demand
08/26/13 | 31951 | Product A | 19120.4003426128 |  | Date | 31952
08/27/13 | 31951 | Product A | 32770.20238106493 |  | 08/26/13 | ??
08/28/13 | 31951 | Product A | 28451.79322997787 |  | 08/27/13 | ??
08/29/13 | 31951 | Product A | 25180.4238639654 |  | 08/28/13 | ??
08/30/13 | 31951 | Product A | 29843.17374496294 |  | 08/29/13 | ??
09/02/13 | 31951 | Product A | 29843.17374496294 |  | 08/30/13 | ??
09/03/13 | 31951 | Product A | 33223.10118191894 |  | 09/02/13 | ??
09/04/13 | 31951 | Product A | 26014.86851220187 |  | 09/03/13 | ??
09/05/13 | 31951 | Product A | 21931.22790851407 |  | 09/04/13 | 670.2189370905066
09/06/13 | 31951 | Product A | 17592.40691558667 |  | 09/05/13 | ??
09/09/13 | 31951 | Product A | 29257.36707625274 |  | 09/06/13 | ??
09/10/13 | 31951 | Product A | 28932.0280655092 |  | 09/09/13 | ??
09/11/13 | 31951 | Product A | 36355.74649630013 |  | 09/10/13 | ??
09/12/13 | 31951 | Product A | 36643.68956087413 |  | 09/11/13 | ??
09/13/13 | 31951 | Product A | 31401.0138859834 |  | 09/12/13 | ??
09/16/13 | 31951 | Product A | 32722.3642426596 |  | 09/13/13 | ??
09/17/13 | 31951 | Product A | 22585.7300478764 |  | 09/16/13 | ??
09/18/13 | 31951 | Product A | 29555.55610081913 |  | 09/17/13 | ??
09/19/13 | 31951 | Product A | 36876.78574868273 |  | 09/18/13 | ??
09/20/13 | 31951 | Product A | 73040.494706186 |  | 09/19/13 | ??
09/23/13 | 31951 | Product A | 76050.81920738067 |  | 09/20/13 | ??
08/26/13 | 31952 | Product B | 17361.1895954674 |  | 09/23/13 | ??
08/27/13 | 31952 | Product B | 23239.40303804747
08/28/13 | 31952 | Product B | 18087.35568159186
08/29/13 | 31952 | Product B | 23053.563040697
08/30/13 | 31952 | Product B | 16669.61479904073
09/02/13 | 31952 | Product B | 16669.61479904073
09/03/13 | 31952 | Product B | 3248.193304398287
09/04/13 | 31952 | Product B | 670.2189370905066
09/05/13 | 31952 | Product B | 8588.362218884467
09/06/13 | 31952 | Product B | 14983.90514669927
09/09/13 | 31952 | Product B | 23934.77505948373
09/10/13 | 31952 | Product B | 15473.863671426
09/11/13 | 31952 | Product B | 15261.370700606
09/12/13 | 31952 | Product B | 9480.787356161665
09/13/13 | 31952 | Product B | 10229.21485109287
09/16/13 | 31952 | Product B | 3820.973537503453
09/17/13 | 31952 | Product B | 4953.941240103533
09/18/13 | 31952 | Product B | 7195.5657548754
09/19/13 | 31952 | Product B | 13994.42193468887
09/20/13 | 31952 | Product B | 43641.2858879552
09/23/13 | 31952 | Product B | 46627.95521618287
08/26/13 | 31955 | Product C | 518534.8786865493
08/27/13 | 31955 | Product C | 591397.2896826133
08/28/13 | 31955 | Product C | 533253.5211528913
08/29/13 | 31955 | Product C | 512731.5204897167
08/30/13 | 31955 | Product D | 567704.4332938333
09/02/13 | 31955 | Product D | 567704.4332938333
09/03/13 | 31955 | Product D | 564944.7677155479
09/04/13 | 31955 | Product D | 533450.0263157086
09/05/13 | 31955 | Product D | 62216.0417497802
09/06/13 | 31955 | Product D | 139178.4604810187
09/09/13 | 31955 | Product D | 96955.95609048667
09/10/13 | 31955 | Product D | 88749.64321663934
09/11/13 | 31955 | Product D | 6092.457293128254
09/12/13 | 31955 | Product D | 198652.0072573513
09/13/13 | 31955 | Product D | 303533.8370954667
09/16/13 | 31955 | Product D | 286950.155571676
09/17/13 | 31955 | Product D | 17817.86323874907
09/18/13 | 31955 | Product D | 534941.0937208846
09/19/13 | 31955 | Product D | 360.520448331758
09/20/13 | 31955 | Product D | 526006.3463411994
09/23/13 | 31955 | Product D | 302057.6604074066