Spreadsheet: 472629d1469689043-vlookup-based-on-a-criteria-account-client-wise
Sheet: Master

NO. | IMEI | RECEIVED ON | SUBMITTED ON | REPLIED ON | STATUS | NO. OF DAYS | CLIENT | COST | CLIENT PAID BY | CLIENT PAID ME | PAID DATE | PAID TO SUNIL | REMARKS
1 | 355409070322593 | NA | 2016-06-06 00:00:00 | 2016-06-28 00:00:00 | Rejected |  | Arsim |  | - |  |  | 560 | -
2 | 352069066537068 | NA | 2016-06-13 00:00:00 | 2016-06-18 00:00:00 | Completed |  | [NAME] |  | - |  |  |  | I incorrectly unlocked this IMEI
3 | 358363067170423 | 2016-06-22 00:00:00 | 2016-06-22 00:00:00 | 2016-07-06 00:00:00 | Completed |  | Chouchane |  | Moneygram | 125 | 2016-07-08 00:00:00 |  | 48661964
4 | 354442060877152 | 2016-06-22 00:00:00 | 2016-06-22 00:00:00 | 2016-07-06 00:00:00 | Completed |  | Chouchane |  | Moneygram | 442.43 | 2016-07-08 00:00:00 |  | 18781295
5 | 352030074483786 | 2016-06-22 00:00:00 | 2016-06-23 00:00:00 | 2016-06-29 00:00:00 | Completed |  | Chouchane
6 | 353270072104419 | 2016-06-22 00:00:00 | 2016-06-23 00:00:00 | 2016-07-04 00:00:00 | Completed |  | Chouchane
7 | 354450067605476 | 2016-06-24 00:00:00 | 2016-06-29 00:00:00 | 2016-07-05 00:00:00 | Completed |  | Brazil |  | Western Union | 135 | 2016-06-23 00:00:00 |  | [PHONE]
8 | 352025078219129 | 2016-06-29 00:00:00 | 2016-06-29 00:00:00 |  | In process |  | Zakawdeen
9 | 358370066492294 | 2016-06-29 00:00:00 | 2016-06-29 00:00:00 | 2016-07-04 00:00:00 | Completed |  | Huzaifa |  | Cash |  | 2016-07-04 00:00:00
10 | 353320076541247 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-27 00:00:00 | Completed |  | Momo |  | Skrill | 130 | 2016-07-03 00:00:00 |  | 1820979542
11 | 359254064387590 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-27 00:00:00 | Completed |  | Momo |  | Skrill | 130 | 2016-07-03 00:00:00 |  | 1820979542
12 | 355418076663512 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-27 00:00:00 | Completed |  | Chouchane |  |  |  |  |  | $10 discount due to delay
13 | 356980065237623 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 |  | In process |  | Chouchane
14 | 352020070476868 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-13 00:00:00 | Completed |  | Chouchane
15 | 352067063704285 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 |  | In process |  | Chouchane
16 | 355424073063672 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-13 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Source rejected
17 | 358762058792659 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-17 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Client requested to cancel
18 | 353317071192497 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-27 00:00:00 | Completed |  | Chouchane |  |  |  |  |  | $10 discount due to delay
19 | 352061068915517 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-21 00:00:00 | Completed |  | Chouchane |  |  |  |  |  | $10 discount due to delay
20 | 355432075070769 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-11 00:00:00 | Completed |  | Chouchane
21 | 353335070712867 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-28 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Client requested to cancel
22 | 353314073133827 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 |  | In process |  | Chouchane
23 | 358369066913002 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-11 00:00:00 | Completed |  | Chouchane
24 | 356953061971735 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-17 00:00:00 | Rejected |  | Chouchane |  | - | - | - |  | Client requested to cancel
25 | 353318079419841 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-25 00:00:00 | Completed |  | Chouchane
26 | 352032075033131 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-17 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Client requested to cancel
27 | 358353064316921 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-25 00:00:00 | Completed |  | Chouchane |  |  |  |  |  | $10 discount due to delay
28 | 353336070334827 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-28 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Client requested to cancel
29 | 352023072409390 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-25 00:00:00 | Completed |  | Chouchane |  |  |  |  |  | $10 discount due to delay
30 | 358367068551713 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-17 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Source rejected
31 | 354449066079691 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-11 00:00:00 | Completed |  | Chouchane
32 | 352092070849055 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 |  | In process |  | Chouchane
33 | 353264071704386 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 |  | In process |  | Chouchane
34 | 354445062502645 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
35 | 354383065672182 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
36 | 356960065010782 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
37 | 353270072719331 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
38 | 354435068766831 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
39 | 359310069874832 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
40 | 354435068766831 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
41 | 359310069874832 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
42 | 353310070204884 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
43 | 354451065567445 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 | 2016-07-28 00:00:00 | Completed |  | Chouchane
44 | 353265079511459 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | Pending |  | Chouchane
45 | 358361068540412 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
46 | 354381069063572 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
47 | 359226069276523 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
48 | 352072061212687 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
49 | 355432075276838 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
50 | 355696078242761 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
51 | 359256061068594 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
52 | 356980060227611 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
53 | 356952060995604 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
54 | 359317064517407 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
55 | 352075062343294 | 2016-07-16 00:00:00 | 2016-07-16 00:00:00 |  | In process |  | Chouchane
56 | 353287078205834 | 2016-07-17 00:00:00 | 2016-07-24 00:00:00 | 2016-07-28 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Client requested to cancel
57 | 359228063650398 | 2016-07-17 00:00:00 | 2016-07-24 00:00:00 | 2016-07-28 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Client requested to cancel
58 | 352070066064301 | 2016-07-17 00:00:00 | 2016-07-17 00:00:00 | 2016-07-28 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Client requested to cancel
59 | 359244068323683 | 2016-07-17 00:00:00 | 2016-07-24 00:00:00 | 2016-07-28 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Client requested to cancel
60 | 358371063529823 | 2016-07-17 00:00:00 | 2016-07-24 00:00:00 | 2016-07-28 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Client requested to cancel
61 | 354381060547425 | 2016-07-17 00:00:00 | 2016-07-24 00:00:00 | 2016-07-28 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Client requested to cancel
62 | 355430075637199 | 2016-07-17 00:00:00 | 2016-07-24 00:00:00 | 2016-07-28 00:00:00 | Rejected |  | Chouchane |  |  |  |  |  | Client requested to cancel
 | TOTAL COST
 | TOTAL IMEIS DONE
 | BALANCE PAYABLE AS AT