Spreadsheet: 114401d1310136217-using-count-and-lookup-maybe-macro-lookup-20help-1-
Sheet: Sheet1

Region | Type | Total Cash | Total Recovered |  |  | Attempted CIT |  | CIT |  | Attempted R |  | ROB
West Region | Attempted R | 0 |  |  | Region | QTY | Cash Loss | QTY | Cash Loss | QTY | Cash Loss | QTY | Cash Loss
West Region | Attempted R | 0 |  |  | West | 0 | 0 | 3 | 5200 | 5 | 0 | 11 | 8036.99
West Region | Attempted R | 0 |  |  | Central
West Region | Attempted R | 0 |  |  | North
West Region | Attempted R | 0 |  |  | South
West Region | CIT | 1000 |  |  | East
West Region | CIT | 1500
West Region | CIT | 2700 |  |  | Type | Attempted R |  | CIT |  | ROB |  | Attempted CIT
West Region | ROB | 180 |  |  | Region | Qty | Cash Loss | Qty | Cash Loss | Qty | Cash Loss | Qty | Cash Loss
West Region | ROB | 541.31 |  |  | West Region | 5 | 0 | 3 | 5200 | 11 | 8036.99 | 0 | 0
West Region | ROB | 300 |  |  | Scotland & Ireland | 11 | 19.04 | 0 | 0 | 6 | 2888.63 | 0 | 0
West Region | ROB | 437.16 |  |  | North Region | 4 | 0 | 6 | 13670 | 11 | 3780.17 | 0 | 0
West Region | ROB | 347.21 |  |  | East Region | 13 | 0 | 9 | 8555 | 13 | 5391.23 | 0 | 0
West Region | ROB | 524.31 |  |  | Central Region | 5 | 12 | 5 | 7480 | 11 | 4927.78 | 1 | 0
West Region | ROB | 1876
West Region | ROB | 96
West Region | ROB | 3180
West Region | ROB | 235
West Region | ROB | 320
Scotland & Ireland | Attempted R | 0
Scotland & Ireland | Attempted R | 0
Scotland & Ireland | Attempted R | 19.04
Scotland & Ireland | Attempted R | 0
Scotland & Ireland | Attempted R | 0
Scotland & Ireland | Attempted R | 0
Scotland & Ireland | Attempted R | 0
Scotland & Ireland | Attempted R | 0
Scotland & Ireland | Attempted R | 0
Scotland & Ireland | Attempted R | 0
Scotland & Ireland | Attempted R | 0
Scotland & Ireland | ROB | 435
Scotland & Ireland | ROB | 460
Scotland & Ireland | ROB | 1254.63
Scotland & Ireland | ROB | 160
Scotland & Ireland | ROB | 414
Scotland & Ireland | ROB | 165 | 0
North Region | Attempted R | 0
North Region | Attempted R | 0
North Region | Attempted R | 0
North Region | Attempted R | 0
North Region | CIT | 3170
North Region | CIT | 2120
North Region | CIT | 3620
North Region | CIT | 2000
North Region | CIT | 1660
North Region | CIT | 1100
North Region | ROB | 193
North Region | ROB | 472
North Region | ROB | 130
North Region | ROB | 228
North Region | ROB | 560
North Region | ROB | 350
North Region | ROB | 707.17
North Region | ROB | 433
North Region | ROB | 340
North Region | ROB | 338
North Region | ROB | 29
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | Attempted R | 0
East Region | CIT | 560
East Region | CIT | 720
East Region | CIT | 1170
East Region | CIT | 45
East Region | CIT | 2860
East Region | CIT | 600
East Region | CIT | 400
East Region | CIT | 200
East Region | CIT | 2000
East Region | ROB | 485
East Region | ROB | 535
East Region | ROB | 227.69
East Region | ROB | 203.5
East Region | ROB | 315
East Region | ROB | 294.54
East Region | ROB | 205 | 205
East Region | ROB | 155.63
East Region | ROB | 1720
East Region | ROB | 100
East Region | ROB | 405
East Region | ROB | 386
East Region | ROB | 358.87
Central Region | Attempted CIT | 0
Central Region | Attempted R | 0
Central Region | Attempted R | 0
Central Region | Attempted R | 0
Central Region | Attempted R | 12
Central Region | Attempted R | 0
Central Region | CIT | 195
Central Region | CIT | 2285
Central Region | CIT | 2000
Central Region | CIT | 2820 | 0
Central Region | CIT | 180
Central Region | ROB | 386.06
Central Region | ROB | 308.28
Central Region | ROB | 690
Central Region | ROB | 60
Central Region | ROB | 1060
Central Region | ROB | 115
Central Region | ROB | 250
Central Region | ROB | 603.99
Central Region | ROB | 299.45
Central Region | ROB | 835
Central Region | ROB | 320