Spreadsheet: 221268d1363450823-to-look-for-a-value-based-on-2-criteria-dummy
Sheet: Sheet1

Date | Lead | Order Date | SKU | Issue | Result
2013-01-01 00:00:00 | thas | 31/12/12 | NI126SE36AOTSG-280881 | [NAME] | [NAME] |  | date to calculate | 2013-01-01 00:00:00 | (I2 to be input by user)
2013-01-01 00:00:00 | thas | 31/12/12 | PO967KD74SEB-166571 | Picker cannot [NAME] | Item in Wrong Location
2013-01-01 00:00:00 | thas | 31/12/12 | SA346KD11WSU-224421 | Picker cannot [NAME] | Found in Original Location
2013-01-01 00:00:00 | thas | 31/12/12 | BE874SH90JUZSG-299067 | Picker cannot [NAME] | Found in Original Location |  |  | thas | manob | keh | rao
2013-01-01 00:00:00 | thas | 2013-01-01 00:00:00 | HA021SH15BPO-234085 | [NAME] | [NAME] |  | defective item | 2 | 0 | 0 | 0
2013-02-01 00:00:00 | thas | 31/12/12 | BL572SH99EEMSG-286944 | Cancellation/ For Refund | Cancellation/ For Refund |  | item in wrong location | 1 | 0 | 0 | 0
2013-02-01 00:00:00 | thas | 31/12/12 | BL572SH01EEKSG-286934 | Cancellation/ For Refund | Cancellation/ For Refund |  | cancellation/for refund | 0 | 0 | 0 | 0
2013-02-01 00:00:00 | thas | 31/12/12 | CA025SH03ZHKSG-278020 | Cancellation/ For Refund | Cancellation/ For Refund |  | item in original location | 2 | 0 | 0 | 0
2013-02-01 00:00:00 | thas | 31/12/12 | SI784SH08KVFSG-301540 | Cancellation/ For Refund | Cancellation/ For Refund |  | lost | 0 | 0 | 0 | 0
2013-02-01 00:00:00 | thas | 31/12/12 | HE793SH37OASSG-309937 | Cancellation/ For Refund | Cancellation/ For Refund
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | MO029KD15YTO-181119 | Picker cannot [NAME] | Found in Original Location
2013-02-01 00:00:00 | thas | 31/12/12 | ON088AA77HZM-198316 | Image doesn't match PET | Wrong SKU Label
2013-02-01 00:00:00 | thas | 31/12/12 | ST983AA36UAP-219207 | Image doesn't match PET | Wrong SKU Label
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | ST983AA46VQN-222193 | Picker cannot [NAME] | Found in Original Location
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | ME733AA16EXBSG-288511 | Picker cannot [NAME] | Found in Original Location
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | KO782SH36KUDSG-301365 | Picker cannot [NAME] | Found in Original Location
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | FL326AC71UWI-220573 | Picker cannot [NAME] | Item in Wrong Location
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | BU419SH60AMX-230566 | Picker cannot [NAME] | Item in Wrong Location
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | KO782SH83KSISG-301085 | Cancellation/ For Refund | Cancellation/ For Refund
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | MI230SH91DXCSG-286335 | Cancellation/ For Refund | Cancellation/ For Refund
2013-02-01 00:00:00 | Manob | 2013-01-01 00:00:00 | GI934AC91XFC-225168 | Picker cannot [NAME] | Found in Original Location
2013-02-01 00:00:00 | Manob | 2013-01-01 00:00:00 | ME676AC74BCRSG-281767 | Picker cannot [NAME] | Item in Wrong Location
2013-02-01 00:00:00 | keh | 2013-01-01 00:00:00 | VR823SH81PUG-162074 | Image doesn't match PET | Wrong SKU Label
2013-02-01 00:00:00 | thas | 2013-02-01 00:00:00 | BR495SH88TRV-266373 | Cancellation/ For Refund | Cancellation/ For Refund
2013-02-01 00:00:00 | thas | 2013-02-01 00:00:00 | BR495SH85TRY-266388 | Cancellation/ For Refund | Cancellation/ For Refund
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | ME424AC34SZT-217326 | Picker cannot [NAME] | Item in Wrong Location
2013-02-01 00:00:00 | thas | 2013-02-01 00:00:00 | ON088AA94DYZ-190240 | Picker cannot [NAME] | Item in Wrong Location
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | CO799AC64OLFSG-310972 | Picker cannot [NAME] | Found in Original Location
2013-02-01 00:00:00 | keh | 2013-01-01 00:00:00 | SO764AA43IVWSG-296568 | Picker cannot [NAME] | Lost
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | ON035AA96UDF-43097 | Picker cannot [NAME] | Lost
2013-02-01 00:00:00 | keh | 2013-01-01 00:00:00 | EV785AA62FCZSG-289255 | Picker cannot [NAME] | Orders > Items
2013-02-01 00:00:00 | thas | 2013-01-01 00:00:00 | SO764AA93ITYSG-296503 | Picker cannot [NAME] | Orders > Items
2013-03-01 00:00:00 | RAO | 2013-02-01 00:00:00 | SK173SP72POT-258127 | Image doesn't match PET | Wrong SKU Label
2013-03-01 00:00:00 | thas | 2013-02-01 00:00:00 | ME121SH57PQGSG-314023 | Cancellation/ For Refund | Cancellation/ For Refund
2013-03-01 00:00:00 | thas | 2013-02-01 00:00:00 | AM805SH97POSSG-313779 | Cancellation/ For Refund | Cancellation/ For Refund
2013-03-01 00:00:00 | thas | 2013-02-01 00:00:00 | SK173SP72POT-258128 | Cancellation/ For Refund | Cancellation/ For Refund
2013-03-01 00:00:00 | RAO | 2013-02-01 00:00:00 | CO799AC67OLCSG-310969 | picker cannot [NAME] | Item in Wrong Location
2013-03-01 00:00:00 | RAO | 2013-02-01 00:00:00 | KR139SH00BRBSG-282696 | picker cannot [NAME] | item in Wrong Location
2013-03-01 00:00:00 | thas | 2013-02-01 00:00:00 | NE811SH30GKB-143959 | [NAME] | [NAME]
2013-03-01 00:00:00 | RAO | 2013-02-01 00:00:00 | TO643AC39GTG-243302 | picker cannot [NAME] | item in Wrong Location
2013-03-01 00:00:00 | RAO | 2013-02-01 00:00:00 | FL326AC70UWJ-220574 | picker cannot [NAME] | item in Wrong Location
2013-03-01 00:00:00 | RAO | 2013-02-01 00:00:00 | FL326AC69UWK-220575 | picker cannot [NAME] | item in Wrong Location
2013-03-01 00:00:00 | thas | 2013-02-01 00:00:00 | NI126SE96IELSG-295121 | Picker cannot [NAME] | Item in Wrong Location
2013-03-01 00:00:00 | thas | 2013-02-01 00:00:00 | PI517AC58HMV-75814 | Cancellation/ For Refund | Cancellation/ For Refund
2013-03-01 00:00:00 | thas | 2013-02-01 00:00:00 | SP621SH83XOASG-274336 | Cancellation/ For Refund | Cancellation/ For Refund
2013-03-01 00:00:00 | thas | 2013-02-01 00:00:00 | EV785AA12HRJ-244517 | Cancellation/ For Refund | Cancellation/ For Refund
2013-03-01 00:00:00 | thas | 2013-02-01 00:00:00 | SP621SH88XNVSG-274312 | Cancellation/ For Refund | Cancellation/ For Refund
2013-03-01 00:00:00 | thas | 2013-03-01 00:00:00 | PA399AC08TNF-266170 | Picker cannot [NAME] | Item in Wrong Location
2013-03-01 00:00:00 | thas | 2013-03-01 00:00:00 | SP621SH84XNZSG-274332 | Cancellation/ For Refund | Cancellation/ For Refund