Spreadsheet: 195562d1353553717-look-up-certain-values-and-then-combine-the-rest-in-to-one-cell-excel-query-moo
Sheet: Look UP

 |  |  |  | Period 01 2012 | Period 02 2012 | Period 03 2012 | Period 04 2012
[NAME] | Prof Name | Product Group | Product Name | Sales Amt-CY-YTD | Sales Amt-CY-YTD | Sales Amt-CY-YTD | Sales Amt-CY-YTD
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | MPS | [NAME] | 321 | 231
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | MPS | [NAME] | 200 | 15325.38 |  | 29726
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | MPS | REVITALENS | 345 |  |  | 0
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | PEROXIDE SOLUTION | PEROXIDE SOLUTION | 2345
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | TEARS | DROPS- B&C & BLINK | 2134 | 5020.8 | 0 | 31254.48
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | REWETTER | BLINK & CLEAN | 2345 | 8419.2 |  | 29921.36
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | OTHER | COMPLETE CASES | 3421
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | UNASSIGNED - EC | UNASSIGNED - EC | 2345
3580/99/01/PROF72001 | ADRIAN PIEKARSKI | OXIDATIVE | OXYSEPT | 2341
3580/99/01/PROF72002 | RICHARD PATMORE | MPS | [NAME] | 2032.92 | 1869.68 | 1923.79 | 1776.13
3580/99/01/PROF72002 | RICHARD PATMORE | MPS | [NAME] | 12955.48 | 24625.11 | 20628.79 | 17487.87
3580/99/01/PROF72002 | RICHARD PATMORE | MPS | REVITALENS | 1109.99 | 8560.57 | 2067.07 | 2864.99
3580/99/01/PROF72002 | RICHARD PATMORE | PEROXIDE SOLUTION | PEROXIDE SOLUTION | 4851.26 | 6016.68 | 6075.01 | 5435.91
3580/99/01/PROF72002 | RICHARD PATMORE | TEARS | DROPS- B&C & BLINK | 5583.57 | 7306.39 | 7597.34 | 5741.53
3580/99/01/PROF72002 | RICHARD PATMORE | REWETTER | BLINK & CLEAN | 3485.13 | 4229.75 | 3427.96 | 4012.64
3580/99/01/PROF72002 | RICHARD PATMORE | REWETTER | PRIVATE LABEL RWTR | 0 | 53.56 | -26.79 | 26.78
3580/99/01/PROF72002 | RICHARD PATMORE | ENZYMES | ENZYMES | 1705.86 | 2378.3 | 520.25 | 1749.24
3580/99/01/PROF72002 | RICHARD PATMORE | RGP | RGP | 869.21 | 1672.21 | 1257.3 | 664.29
3580/99/01/PROF72002 | RICHARD PATMORE | SALINES | SALINES | 894.56 | 1099.9 | 687.16 | 1033.6
3580/99/01/PROF72002 | RICHARD PATMORE | OTHER | COMPLETE CASES |  |  | 144.5 | 144.5
3580/99/01/PROF72002 | RICHARD PATMORE | OTHER | OTHER | 1179 | 1414.8 | 471.6 | 628.8
3580/99/01/PROF72002 | RICHARD PATMORE | COR L1 UNDEF | COR L2 UNDEF |  |  | 0
3580/99/01/PROF72002 | RICHARD PATMORE | UNASSIGNED - EC | UNASSIGNED - EC | 220 | 375 | 530 | 225
3580/99/01/PROF72002 | RICHARD PATMORE | OXIDATIVE | OXYSEPT
3580/99/01/PROF72003 | VACANT NSW | MPS | [NAME] | 2032.92 | 1869.68 | 1923.79 | 1776.13
3580/99/01/PROF72003 | VACANT NSW | MPS | [NAME] | 13157.96 | 25655.18 | 23167.69 | 15607.57
3580/99/01/PROF72003 | VACANT NSW | MPS | REVITALENS | 1283.2 | 7011.3 | 3932.57 | 2707.86
3580/99/01/PROF72003 | VACANT NSW | PEROXIDE SOLUTION | PEROXIDE SOLUTION | 5358.35 | 6766.02 | 6761.27 | 5169.73
3580/99/01/PROF72003 | VACANT NSW | TEARS | DROPS- B&C & BLINK | 6014.99 | 9016.1 | 7838 | 6922.4
3580/99/01/PROF72003 | VACANT NSW | REWETTER | BLINK & CLEAN | 2539.93 | 3253.47 | 2358.37 | 3141.51
3580/99/01/PROF72003 | VACANT NSW | REWETTER | PRIVATE LABEL RWTR | 0 | 53.56 | -26.79 | 26.78
3580/99/01/PROF72003 | VACANT NSW | ENZYMES | ENZYMES | 2026.32 | 2248.66 | 757.38 | 1725.04
3580/99/01/PROF72003 | VACANT NSW | RGP | RGP | 471.54 | 1451.87 | 1470.59 | 632.43
3580/99/01/PROF72003 | VACANT NSW | SALINES | SALINES | 813.76 | 1382.78 | 792.76 | 519.36
3580/99/01/PROF72003 | VACANT NSW | OTHER | COMPLETE CASES | 181.05 | 221 | 158.95 | 144.5
3580/99/01/PROF72003 | VACANT NSW | OTHER | OTHER | 275.1 | 393 | 864.6 | 235.8
3580/99/01/PROF72003 | VACANT NSW | COR L1 UNDEF | COR L2 UNDEF |  | 0
3580/99/01/PROF72003 | VACANT NSW | UNASSIGNED - EC | UNASSIGNED - EC | 100 | 290 | 230 | 235
3580/99/01/PROF72003 | VACANT NSW | OXIDATIVE | OXYSEPT