Spreadsheet: 193033d1352709405-lookup-with-two-criteria-formual-not-working-lookup-using-two-conditions
Sheet: Look UP Data

Condition 2 |  | Condition 1 | 2012 | 2012 | 2012
 |  |  | January | February | March
3000001 | 02CAT | Cataract | 836.554570001 | 1427.108630002 | 1452.339810002
3000001 | 02PCIOL | PC IOL | 23.973 | 63.614 | 77.0225
3000001 | TMF1ACR | TECNIS MF 1 PC (ACR) | 19.723 | 52.192 | 46.601
3000001 | TMF3ACR | TECNIS MF 3PC (ACR) | 2.6 | 7.972 | 17.244
3000001 | TMFTOR | [NAME] TORIC (ACR
3000001 | PHAIOL | PHAKIC IOL'S | 1.44 | 3.45 | 12.9675
3000001 | OTHPCI | OTHER PC IOL'S | 0.21 |  | 0.21
3000001 | 02PRIOL | Premium IOL | 380.999000001 | 689.183000001 | 737.018000001
3000001 | TEC1ACR | TECNIS 1 PC (ACR) | 233.11 | 388.818000001 | 419.468000001
3000001 | TEC3ACR | TECNIS 3PC (ACR) | 65.279 | 136.317 | 139.282
3000001 | TECTACR | TECNIS TORIC (ACR) | 82.61 | 164.048 | 178.268
3000001 | 02NPIOL | Non-Premium IOL | 54.815 | 110.676 | 136.234
3000001 | TCLSIL | TECNIS CL (SIL) | 36.881 | 87.178 | 101.596
3000001 | CLARIF | CLARIFLEX (SIL) | 0.5 |  | 0.644
3000001 | SENSAR | SENSAR 3pc (Acr) | 17.236 | 23.3 | 33.598
3000001 | OTHIOL | OTHER CAT IOL'S | 0.198 | 0.198 | 0.396
3000001 | 02PHACO | Phaco & Packs | 216.49707 | 309.10938 | 272.70131
3000001 | PHAEQU | Phaco Equipment
3000001 | PHAPAC | PACKS | 164.74802 | 212.75522 | 198.63822
3000001 | PHATIP | TIPS | 38.568 | 44.283 | 53.166
3000001 | PHAOTH | ACCESSORIES & OTHER | 13.18105 | 52.07116 | 20.89709
3000001 | 02OVD | OVD | 134.7855 | 221.95325 | 202.694
3000001 | OVDCOH | COHESIVE | 134.7855 | 221.95325 | 202.694
3000001 | OVDDIS | DISPERSIVE
3000001 | 02OTHCAR | Other Cataract | 25.485 | 32.573 | 26.67
3000001 | OTHSTA | STABIL EYES | 1.59 | 2.951 | 0.277
3000001 | OTHSHU | SHUNTS | 12.675 | 12.3 | 11.825
3000001 | OTHCAR | ADJUNCTS & OTHER | 11.22 | 17.322 | 14.568
3000004 | 02CAT | Cataract | -4.09175 | -1.1383 | -9.75671
3000004 | 02PRIOL | Premium IOL |  |  | -8.6184
3000004 | TECTACR | TECNIS TORIC (ACR) |  |  | -8.6184
3000004 | 02PHACO | Phaco & Packs | -4.09175 | -1.1383 | -1.13831
3000004 | PHAEQU | Phaco Equipment
3000004 | PHAPAC | PACKS | -4.09175 | -1.1383 | -1.13831
3000101 | 02CAT | Cataract | -37.979 | 8.762 | 17.9204
3000101 | 02PCIOL | PC IOL |  | -0.68 | 0.68
3000101 | PHAIOL | PHAKIC IOL'S |  | -0.68 | 0.68
3000101 | 02PHACO | Phaco & Packs | -23.92 | 7.012 | 5.7764
3000101 | PHAPAC | PACKS | -21.628 | 6.976 | 8.4264
3000101 | PHATIP | TIPS | -2.112 | -0.144 | 0.144
3000101 | PHAOTH | ACCESSORIES & OTHER | -0.18 | 0.18 | -2.794
3000101 | 02OVD | OVD | -11.304 | 1.618 | 9.686
3000101 | OVDCOH | COHESIVE | -11.304 | 1.618 | 9.686
3000101 | 02OTHCAR | Other Cataract | -2.755 | 0.812 | 1.778
3000101 | OTHSTA | STABIL EYES |  | -0.318 | 0.318
3000101 | OTHSHU | SHUNTS | -1.7 | 1.275 | 0.425
3000101 | OTHCAR | ADJUNCTS & OTHER | -1.055 | -0.145 | 1.035
3400001 | 02CAT | Cataract | -9.826 | -6.822 | -42.858
3400001 | 02PCIOL | PC IOL | 0 |  | -4.812
3400001 | TMF1ACR | TECNIS MF 1 PC (ACR) | 0 |  | -2.322
3400001 | PHAIOL | PHAKIC IOL'S |  |  | -2.49
3400001 | 02PRIOL | Premium IOL | -6.692 | -6.382 | -17.802
3400001 | TEC1ACR | TECNIS 1 PC (ACR) | -4.732 | -5.092 | -11.102
3400001 | TEC3ACR | TECNIS 3PC (ACR) | 0 | -0.728 | -2.82
3400001 | TECTACR | TECNIS TORIC (ACR) | -1.96 | -0.562 | -3.88
3400001 | 02NPIOL | Non-Premium IOL | -0.32 | -0.44 | -3.064
3400001 | TCLSIL | TECNIS CL (SIL) |  | -0.22 | -2.884
3400001 | CLARIF | CLARIFLEX (SIL) | -0.32 |  | 0
3400001 | SENSAR | SENSAR 3pc (Acr) | 0 | -0.22 | -0.18
3400001 | 02PHACO | Phaco & Packs | -1.284 |  | -13.38
3400001 | PHAPAC | PACKS | -1.284 |  | -8.44
3400001 | PHATIP | TIPS | 0
3400001 | PHAOTH | ACCESSORIES & OTHER |  |  | -4.94
3400001 | 02OVD | OVD
3400001 | OVDCOH | COHESIVE
3400001 | 02OTHCAR | Other Cataract | -1.53 |  | -3.8
3400001 | OTHSHU | SHUNTS | 0 |  | -3.8
3400001 | OTHCAR | ADJUNCTS & OTHER | -1.53
3810005 | 02CAT | Cataract | -5.49354 | -7.73823 | -10.52
3810005 | 02PRIOL | Premium IOL
3810005 | TEC1ACR | TECNIS 1 PC (ACR)
3810005 | 02OVD | OVD | -0.42754 | -3.45823 | -4.4315
3810005 | OVDCOH | COHESIVE | -0.42754 | -3.45823 | -4.4315
3810005 | 02OTHCAR | Other Cataract | -5.066 | -4.28 | -6.0885
3810005 | OTHCAR | ADJUNCTS & OTHER | -5.066 | -4.28 | -6.0885
3890006 | 02CAT | Cataract |  |  | -16.69332
3890006 | 02PCIOL | PC IOL |  |  | -2.30472
3890006 | PHAIOL | PHAKIC IOL'S |  |  | -2.30472
3890006 | 02PRIOL | Premium IOL |  |  | -14.03829
3890006 | TEC1ACR | TECNIS 1 PC (ACR) |  |  | -8.61976
3890006 | TEC3ACR | TECNIS 3PC (ACR) |  |  | -5.41853
3890006 | 02NPIOL | Non-Premium IOL |  |  | 0.26996
3890006 | TCLSIL | TECNIS CL (SIL) |  |  | -0.13044
3890006 | CLARIF | CLARIFLEX (SIL) |  |  | 0.4144
3890006 | OTHIOL | OTHER CAT IOL'S |  |  | -0.014
3890006 | 02PHACO | Phaco & Packs |  |  | -2.03146
3890006 | PHAPAC | PACKS |  |  | -0.79928
3890006 | PHATIP | TIPS |  |  | -1.23218
3890006 | 02OVD | OVD |  |  | 1.41119
3890006 | OVDCOH | COHESIVE |  |  | 1.41119