Spreadsheet: 199645d1355272021-lookup-with-multiple-criteria-multiple-look-up-formula
Sheet: Sheet1

 | 6.2011 | Grand Total
Adjunts
[NAME] | 504 | 2080 |  | Would like to get a look up formula matching [NAME], Product Category and  Name
[NAME] | 510 | 16657
TECNIS TORIC
[NAME]
[NAME]
Sum of   Netinv.sls |  |  | Period
[NAME] | Name | Product Category | 2.2011 | 3.2011 | 4.2011 | 5.2011 | 6.2011 | 7.2011 | 8.2011 | 9.2011 | 10.2011 | 11.2011 | Grand Total
TM72001 | [NAME] | Adjuncts | 0 | 0 | 800 | -400 | 504 | 0 | 336 | 504 | 168 | 168 | 2080
 |  | Clariflex |  |  |  |  |  |  |  | 467 |  | 0 | 467
 |  | Disp Tubing | 9480 | 7916 | 9306 | 14400 | 16626 | 19164 | 21936 | 15516 | 16524 | 19728 | 150596
 |  | Healon | 2508 | 1718 | 2260 | 3210 | 3508 | 1058 | 3250 | 4370 | 1212 | 3518 | 26612
 |  | Others | 65 | 198 |  | 198 | 198 | 0 | 832.5 | 598 | 400 | 598 | 3087.5
 |  | Phaco ACC |  |  | 0 | 0 | 483 | 324 | 1721 |  |  |  | 2528
 |  | Phaco EQUIP |  |  | 40000 | 80000 | 77500 | 0 |  |  |  |  | 197500
 |  | Phaco Tips | 2256 | 2184 |  | 3696 | 1056 | 1746 | 2982 | 1020 | 396 | 1614 | 16950
 |  | Sensar | 702 | 190 | 190 |  | 415 | 720 | 170 | 395 | 170 | 170 | 3122
 |  | Shunts |  | 850 |  |  |  | 425 | 850 | 0 | 1700 |  | 3825
 |  | [NAME] |  |  |  | 2226 |  | 1590 | 3339 | 1590 |  |  | 8745
 |  | Tecnis 1-Piece | 21095 | 37727 | 27642 | 37515 | 43491 | 37621 | 30874 | 30433 | 33833 | 35585 | 335816
 |  | Tecnis 3-Piece | 1456 | 1820 | 1092 | 943 | 2184 | 728 | 943 | 364 | 364 | 1711 | 11605
 |  | Tecnis CL | 7329 | 10995 | 6141 | 16783 | 15364 | 13091 | 11659 | 14719 | 6876 | 17433 | 120390
 |  | TECNIS TORIC |  |  |  |  |  |  |  |  | 13278 | 26280 | 39558
 |  | TMF ACRYLIC 1-P | 2700 | 900 | 822 | 822 | 6072 | 2550 | 2700 | 3366 | 4344 | 13308 | 37584
 |  | TMF ACRYLIC 3-P |  | 15150 | 1300 | 27300 | 18850 | 19500 | 25350 | 22100 | 5850 | 15600 | 151000
 |  | VERISYSE APHAKIC | 450 |  | 680 | 680 |  |  |  | 680 |  |  | 2490
 |  | HealonGV | 240 | 2240 | 2790 | 3440 | 2290 | 1620 | 1800 | 2960 | 2290 | 2850 | 22520
 |  | Healon5 | 480 | 1360 | 1100 | 780 | 950 | 1270 | 310 | 1755 | 560 | 630 | 9195
 | [NAME] |  | 48761 | 83248 | 94123 | 191593 | 189491 | 101407 | 109052.5 | 100837 | 87965 | 139193 | 1145670.5
TM72001 Total |  |  | 48761 | 83248 | 94123 | 191593 | 189491 | 101407 | 109052.5 | 100837 | 87965 | 139193 | 1145670.5
TM72002 | [NAME] | Adjuncts | 800 | 2054 | 750 | 3784 | 510 | 2289 | 1514 | 2555 | 1391 | 1010 | 16657
 |  | Clariflex |  |  |  | 502 | 322 | 322 |  | 502 | 180 | 0 | 1828
 |  | Disp Tubing | 12366.4 | 25358 | 20741.2 | 30852 | 21142 | 22000 | 25800 | 33648 | 20456 | 21492 | 233855.6
 |  | Healon | 9092 | 25150 | 16696 | 14712 | 8910 | 11417 | 14916 | 18592 | 17538 | 23630 | 160653
 |  | Others | 0 | 1650 | 0 | 825 | 0 | 0 | 5925 | -627 | 0 | 0 | 7773
 |  | Phaco ACC | 0 | 445 | 1235 | 0 | 0 | 265 | 810 | 530 | 0 | 0 | 3285
 |  | Phaco EQUIP |  |  |  |  |  |  | 42500 |  |  |  | 42500
 |  | Phaco Tips | 2640 | 2640 | 7536 | 7752 | 5952 | 4224 | 3696 | 4896 | 2712 | 1056 | 43104
 |  | Sensar | 5424 | 6864 | 3808 | 4588 | 2484 | 2886 | 4194 | 5860 | 2264 | 1330 | 39702
 |  | Shunts | 425 |  |  |  |  |  |  |  |  |  | 425
 |  | [NAME] |  |  |  |  | 159 |  | 636 |  | 159 |  | 954
 |  | Tecnis 1-Piece | 16002 | 20502 | 18450 | 36518 | 30678 | 24816 | 32808 | 27658 | 31824 | 24440 | 263696
 |  | Tecnis 3-Piece | 25038 | 28310 | 20242 | 28018 | 37504 | 22930 | 24036 | 26262 | 22274 | 35400 | 270014
 |  | Tecnis CL | 21142 | 31780.09 | 25170 | 33539.91 | 30636 | 39030.09 | 43376 | 37239 | 30147 | 30437 | 322497.09
 |  | TECNIS TORIC |  |  |  |  | 26589 |  | 2220 | 4440 | 19220 | 21040 | 46920
 |  | TMF ACRYLIC 1-P | 4110 | 2466 | 2466 | 1644 | 5466 | 822 | 4932 | 822 | -822 | 2466 | 24372
 |  | HealonGV | 960 | 1520 | 1200 |  | 80 | 720 | 1280 |  | 720 | 2080 | 8560
 |  | Healon5 |  | 2800 | 1600 | 1200 | 2800 | 3200 | 1600 | 2000 | 1600 | 3120 | 19920
 | Melinda Wood Total |  | 97999.4 | 151539.09 | 119894.2 | 163934.91 | 146643 | 134921.09 | 210243 | 164377 | 149663 | 167501 | 1506715.69