Spreadsheet: 65592d1266316832-vlookup-multiple-criteria-multiple-data-returned-example
Sheet: Source Data

No | Address 1 | Address 2 | Town | Postcode | Forename | Surname | Make of Lift | Serial number | Last Inspection Date | Next Inspection Date | Last Service Date | Next Service Date | Sling/Size/Type | Serial No | Comments | N/o | Address | Telephone | [NAME] | [NAME] | Serial Number | Month | 2nd Month Visit | Sling No 1 | Sling No 2 | Sling No 3 | Sling No 4
1 | Address A1 | Address B1 | Rochdale | OL11 1TZ | Person | 1 | 1. Oxford Midi Electrical            2. Westholme Transactive         3. Westholme Transactive          4. Mechanaid - Bath Hoist | 1000 | 2. - 4. 09/10/09         1. 09/09/2009 | 2. - 4. -09/04/2010       1. 09/03/2010 | 2009-06-03 00:00:00 | 2009-12-03 00:00:00 | 1. M Q/Fit Deluxe            2. M Q/Fit Deluxe | 12020 |  | #N/A
1 | Address A2 | Address B2 | Littleborough | OL15 9AH | Person | 2 | Freeway 150 Hydraulic | 2000 | 2009-07-17 00:00:00 | 2010-01-17 00:00:00 |  |  | 1. M F/Way Hammock    2. M F/Way Hammock | 20202010
2 | Address A3 | Address B3 | Rochdale | OL12 7AP | Person | 3 | Ceiling Track Hoist | 3000 | 2009-09-17 00:00:00 | 2010-03-17 00:00:00 |  |  | 1. M F/Way Hammock    2. M Dual Access | 30202020 | Client Deceased - No order for removal yet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inspected by [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Originally serviced and examined by ARJO recently transferred over to Adult Care
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inspected by [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Caricare Hoist originally serviced and examined by ARJO recently transferred over to Adult Care
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Visiting 04/08/09 (Zurich
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sling audit completed - passed for re-assessment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sling audit pending
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Slings examined at same time as hoist
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inspected by [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sling audit pending - Client on Holiday - Inspected by [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hoists/Slings not currently in use - passed for re-assessment (ACCSS OT)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Referred for re-assessment of slings Zurich unable to gain access for Thorough Examination on 16/12/09
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sling not suitable - passed for re-assessment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Access 9th + 19th June for Service
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sling audit pending - No access
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Service calendar on sling - needs tagging/replacing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Awaiting Crimson update for location - showing at warehouse - Zurich informed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not on Zurich - Email sent to [NAME] to inspect ASAP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sling audit completed - awaiting new slings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Commissioned/Serviced by Essential Healthcare on delivery - 19/11/09
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sling audit completed - passed for re-assessment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Slings examined at same time as hoist
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A for Zurich inspection 03/08/09 - Sent Text message to mobile to arrange callback for Zurich inspection
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A for Zurich inspection 03/08/09 - L/Mess 03/08/09 to arrange visit for Zurich - Out of the country, not known when returning