Spreadsheet: 47913d1247084674-and-if-actual-vs-pos
Sheet: POS

Customer | Yr / Month | [NAME] | Customer Name | P/N | POS | Actual
#N/A | 2009_01 | 360 SY | 360 SYSTEMS | SN74LV393APW | 29
#N/A | 2009_02 | 360 SY | 360 SYSTEMS | SN65LVDS2DBV | 413
#N/A | 2009_03 | 360 SY | 360 SYSTEMS | SN74LVC4245ADW | 75
#N/A | 2009_01 | A&M EL | A&M ELECTRONI | SN74LS14N | 24
#N/A | 2009_02 | A&M EL | A&M ELECTRONI | SN74LS14D | 9 | If customer names match on "POS" & "Actual", then check P/N on "POS" with P/N on "Actual", then check month on "POS" with month on "Actual", then pull over cololating amount from "Actual"
#N/A | 2009_02 | A&M EL | A&M ELECTRONI | SN74LS14N | 48
ADVANCED MOTION | 2009_01 | ADVANC | ADVANCED MOTION | UC2843ADT | 6375 | My overall outcome would be: If [NAME], Month, P/N are all the same, then what is the $$ from Actual.  (I need to insure that  the $ matches with the correct monoth)
ADVANCED MOTION | 2009_02 | ADVANC | ADVANCED MOTION | TMS320LF2407APGEA | 4415
ADVANCED MOTION | 2009_03 | ADVANC | ADVANCED MOTION | SN74LVC2G17DBV | 720
ADVANCED MOTION | 2009_03 | ADVANC | ADVANCED MOTION | TMS320F2811PBKA | 3453
ADVANCED MOTION | 2009_04 | ADVANC | ADVANCED MOTION | UC2843ADT | 2125
ADVANCED MOTION | 2009_05 | ADVANC | ADVANCED MOTION | SN74LVC4245APW | 580
ADVANCED MOTION | 2009_05 | ADVANC | ADVANCED MOTION | SN74LVC2G17DBV | 720
ADVANCED MOTION | 2009_01 | ADVANC | ADVANCED MOTION C | SN74AHC14PW | 160
ADVANCED MOTION | 2009_03 | ADVANC | ADVANCED MOTION C | TMS320F206PZ | 13104
ADVANCED MOTION | 2009_03 | ADVANC | ADVANCED MOTION C | INA117KU | 270
ADVANCED MOTION | 2009_03 | ADVANC | ADVANCED MOTION C | TMS320LC206PZ80 | 18369
ADVANCED MOTION | 2009_04 | ADVANC | ADVANCED MOTION C | TLV2231IDBV | 120
ADVANCED MOTION | 2009_05 | ADVANC | ADVANCED MOTION C | TMS320LC206PZ80 | 9420
ADVANCED MOTION | 2009_05 | ADVANC | ADVANCED MOTION C | CD4504BPW | 1080
DOREMI | 2009_01 | DOREMI | DOREMI LABS, | MC33078D | 55
DOREMI | 2009_02 | DOREMI | DOREMI LABS, | TFP410PAP | 285
DOREMI | 2009_03 | DOREMI | DOREMI LABS, | CDCVF2505D | 75
DOREMI | 2009_04 | DOREMI | DOREMI LABS, | PT78HT205S | 432
DOREMI | 2009_04 | DOREMI | DOREMI LABS, | PTH05060WAH | 900
DOREMI | 2009_05 | DOREMI | DOREMI LABS, | CDCVF25081D | 145
FUTURELOGIC | 2009_02 | FUTURE | FUTURE LOGIC | TPS62007DGS | 848
GTRAN | 2009_03 | GTRAN | GTRAN | DRV591VFP | 1180
GTRAN | 2009_05 | GTRAN | GTRAN | TMS320F2809GGMA | 2046
[NAME] | 2009_03 | ITT | ITT AERO | LT1013MJG | 865
MARTEK POWER | 2009_03 | MARTEK | MARTEK POWER ABBO | UC3856DW | 9050
MEDTRONIC | 2009_02 | MEDTRO | MEDTRONIC MINIMED | MSP430F2012IRSA | 4050
MEDTRONIC | 2009_03 | MEDTRO | MEDTRONIC MINIMED | CC2430ZF128RTC | 13625
MOORE INDUSTRIES | 2009_01 | MOORE | MOORE INDUSTRIES | TLC3702IP | 95
MOORE INDUSTRIES | 2009_02 | MOORE | MOORE INDUSTRIES | UC2845D8 | 650
MOORE INDUSTRIES | 2009_03 | MOORE | MOORE INDUSTRIES | TLC27L4CN | 60
MRV COMMUNICATIONS | 2009_01 | MRV CO | MRV COMM-KITTING | SN74AHCT1G14DCKR**NBS | 56
MRV COMMUNICATIONS | 2009_02 | MRV CO | MRV COMM-KITTING | [NAME] | 175
MRV COMMUNICATIONS | 2009_03 | MRV CO | MRV COMM-KITTING | [NAME] | 145
MRV COMMUNICATIONS | 2009_03 | MRV CO | MRV COMM-KITTING | SN74AHCT1G14DCK | 56
MRV COMMUNICATIONS | 2009_05 | MRV CO | MRV COMM-KITTING | SN74AHCT1G14DCK | 56
MRV COMMUNICATIONS | 2009_01 | MRV CO | MRV COMMUNICAT*EC | SN74LVC2G241DCU | 2409
MRV COMMUNICATIONS | 2009_01 | MRV CO | MRV COMMUNICAT*EC | PTH05050WAH | 93
MRV COMMUNICATIONS | 2009_02 | MRV CO | MRV COMMUNICAT*EC | TL3016ID | 93
MRV COMMUNICATIONS | 2009_03 | MRV CO | MRV COMMUNICAT*EC | TLK2711JRZQE | 21
MRV COMMUNICATIONS | 2009_04 | MRV CO | MRV COMMUNICAT*EC | TL084ID | 536
MRV COMMUNICATIONS | 2009_05 | MRV CO | MRV COMMUNICAT*EC | CD74HC08M | 170