Spreadsheet: 58862d1259142424-vlookup-from-3-different-work-sheets-vlookup-help
Sheet: T & E

Ship to | Ship_To_&_Hospital_No | Account_Manager | Field_Sales_Manager
1072807 | ROYAL BERKS & BATTLE HOSP BERKSHIRE | [NAME] | [NAME]
1109286 | RAMSAY CLIFTON PARK NHS TREATMENT CENTRE YORK | [NAME] | [NAME]
1151492 | ST WOOLOS HOSPITAL NEWPORT | [NAME] | [NAME]
1154167 | CHESHIRE & MERSEYSIDE RUNCORN | [NAME] | [NAME]
1212259 | QUEENS HOSPITAL | [NAME] | [NAME]
1257334 | DERBY CITY GENERAL HOSPITAL DERBY | [NAME] | [NAME]
1367832 | RAMSEY NOTTINGHAM NOTTINGHAM | [NAME] | [NAME]
25540 | CLATTERBRIDGE HOSPITAL WIRRAL | [NAME] | [NAME]
304207 | NORFOLK & NORWICH UNI HOSP NORWICH | [NAME] | [NAME]
31325 | BMI RUNNYMEDE HOSPITAL | [NAME] | [NAME]
31421 | BARNET GENERAL HOSPITAL | [NAME] | [NAME]
31448 | COUNTESS OF CHESTER HOSP | [NAME] | [NAME]
31472 | WEXHAM PARK HOSPITAL | [NAME] | [NAME]
31481 | HEATHERWOOD HOSPITAL | [NAME] | [NAME]
31536 | SELLY OAK HOSPITAL | [NAME] | [NAME]
31587 | BOLTON ROYAL HOSPITAL | [NAME] | [NAME]
31616 | CENTRAL MIDDLESEX HOSPITA | [NAME] | [NAME]
31624 | NORTHWICK PARK HOSPITAL | [NAME] | [NAME]
31659 | PRINCESS ROYAL UNIVERSITY | [NAME] | [NAME]
31691 | MILTON KEYNES GENERAL HPL | [NAME] | [NAME]
31704 | CAMBRIDGE UNIVERSITY HOSPITALS NHS | [NAME] | [NAME]
31712 | HINCHINGBROOKE HOSPITAL | [NAME] | [NAME]
31721 | MAIDSTONE HOSPITAL | [NAME] | [NAME]
31747 | EDITH CAVELL HOSPITAL | [NAME] | [NAME]
31763 | WARRINGTON DIST GEN HOSP | [NAME] | [NAME]
31780 | LEIGHTON HOSPITAL | [NAME] | [NAME]
31819 | UNIVERSITY HOSPITAL OF NORTH TEES | [NAME] | [NAME]
31835 | ABERGELE HOSPITAL | [NAME] | [NAME]
31843 | WREXHAM MAELOR HOSPITAL | [NAME] | [NAME]
31851 | TRELISKE HOSPITAL | [NAME] | [NAME]
31886 | MAYDAY HOSPITAL | [NAME] | [NAME]
31894 | WEST CUMBERLAND HOSPITAL | [NAME] | [NAME]
31923 | [NAME] INFIRMARY DERBY | [NAME] | [NAME]
31931 | PRINCESS ELIZABETH ORTHO | [NAME] | [NAME]
31982 | DERRIFORD GENERAL HOSPITL | [NAME] | [NAME]
32011 | TORBAY HOSPITAL DEVON | [NAME] | [NAME]
32029 | DONCASTER ROYAL INFIRMARY | [NAME] | [NAME]
32061 | DORSET COUNTY HOSPITAL | [NAME] | [NAME]
32070 | DUMFRIES AND GALLOWAY DUMFRIES | [NAME] | [NAME]
32096 | DARLINGTON [NAME] | [NAME] | [NAME]
32109 | WITHYBUSH HOSPITAL | [NAME] | [NAME]
32117 | BRONGLAIS GENERAL HOSPITA | [NAME] | [NAME]
32150 | ROYAL SUSSEX COUNTY HOSPI | [NAME] | [NAME]
32176 | EASTBOURNE DIST GENERAL | [NAME] | [NAME]
32205 | NORTH MIDDLESEX HOSPITAL | [NAME] | [NAME]
32248 | [NAME] | [NAME] | [NAME]
32272 | COLCHESTER GEN HOSP-IMPLANTS | [NAME] | [NAME]
32281 | PRINCESS ALEXANDRA HOSP-H | [NAME] | [NAME]
32301 | SOUTHEND HOSPITAL | [NAME] | [NAME]
32336 | CHELTENHAM GENERAL HOSPIT | [NAME] | [NAME]
32352 | SOUTHERN GENERAL HPL | [NAME] | [NAME]
32395 | NEVILL HALL HOSPITAL | [NAME] | [NAME]
32408 | QUEEN ALEXANDRA HOSP-PORT | [NAME] | [NAME]
32432 | SOUTHAMPTON GENERAL [NAME] SOUTHAMPTON | [NAME] | [NAME]
32459 | ALEXANDRA HOSPITAL | [NAME] | [NAME]
32467 | HEREFORD GENERAL HOSPITAL | [NAME] | [NAME]
32475 | WORCESTER ROYAL INFIRMARY | [NAME] | [NAME]
32491 | LISTER HOSPITAL-STEVENAGE | [NAME] | [NAME]
32539 | HILLINGDON HOSPITAL | [NAME] | [NAME]
32555 | CASTLE HILL HOSPITAL | [NAME] | [NAME]
32571 | SCUNTHORPE GENERAL HOSPIT | [NAME] | [NAME]
32580 | GOOLE DISTRICT HOSPITAL | [NAME] | [NAME]
32598 | ISLE OF WIGHT HEALTHCARE ISLE OF WIGHT | [NAME] | [NAME]
32601 | ST MARYS HOSPITAL-LONDON | [NAME] | [NAME]
32678 | KINGSTON HOSPITAL-SURREY | [NAME] | [NAME]
32707 | ST THOMAS HOSPITAL-LONDON | [NAME] | [NAME]
32774 | VICTORIA HOSPITAL | [NAME] | [NAME]
32803 | [NAME] INFIRMARY | [NAME] | [NAME]
32820 | SHAROE GREEN HOSPITAL | [NAME] | [NAME]
32846 | LEEDS GENERAL INFIRMARY LEEDS | [NAME] | [NAME]
32862 | CHAPEL ALLERTON HOSPITAL | [NAME] | [NAME]
32871 | WHARFEDALE GENERAL HOSPTL | [NAME] | [NAME]
32897 | LEICESTER GENERAL HOSPITAL | [NAME] | [NAME]
32900 | LEICESTER [NAME] | [NAME] | [NAME]
32977 | PILGRIM HOSPITAL | [NAME] | [NAME]
33021 | MANCHESTER ROYAL INFIRMAR | [NAME] | [NAME]
33072 | WYTHENSHAWE HOSPITAL | [NAME] | [NAME]
33081 | [NAME] | [NAME] | [NAME]
331045 | RUSSELLS HALL HOSPITAL DUDLEY | [NAME] | [NAME]
33128 | NEWCASTLE GENERAL HOSPTAL | [NAME] | [NAME]
33136 | QUEEN [NAME] | [NAME] | [NAME]
33144 | [NAME] | [NAME] | [NAME]
33152 | HARROGATE DISTRICT HOSPIT | [NAME] | [NAME]
33161 | FRIARAGE HOSPITAL | [NAME] | [NAME]
33195 | YORK DISTRICT HOSPITAL | [NAME] | [NAME]
33208 | KETTERING GEN HOSPITAL | [NAME] | [NAME]
33216 | NOTTINGHAM CITY HOSPITAL | [NAME] | [NAME]
33241 | NUFFIELD ORTHOPAEDIC CENT | [NAME] | [NAME]
33275 | ROCHDALE INFIRMARY | [NAME] | [NAME]
33304 | ROTHERHAM GENERAL HOSPITAL | [NAME] | [NAME]
33321 | ST HELENS HOSPITAL | [NAME] | [NAME]
33339 | WHISTON HOSPITAL | [NAME] | [NAME]
33347 | ROYAL SHREWSBURY HOSPITAL SHREWSBURY | [NAME] | [NAME]
33363 | ROBERT JONES & AGNES HUNT | [NAME] | [NAME]
33380 | NORTHERN GENERAL HOSPITAL SHEFFIELD | [NAME] | [NAME]
33427 | NORTH STAFF ROYAL INF | [NAME] | [NAME]
33451 | STEPPING HILL HOSPITAL | [NAME] | [NAME]
33507 | IPSWICH HOSPITAL | [NAME] | [NAME]
33523 | ROYAL SURREY COUNTY HOSP | [NAME] | [NAME]
33540 | FRIMLEY PARK HOSPITAL | [NAME] | [NAME]
33558 | TRAFFORD GENERAL HOSPITAL | [NAME] | [NAME]
33574 | WALSALL DIST GEN HOSPITAL | [NAME] | [NAME]
33591 | GEORGE ELIOT HOSPITAL | [NAME] | [NAME]
33603 | WARWICK HOSPITAL WARWICK | [NAME] | [NAME]
33611 | WESTON GENERAL HOSPITAL | [NAME] | [NAME]
33654 | PRINCESS ROYAL HOSP-HAYWA | [NAME] | [NAME]
33873 | ROYAL UNITED HOSPITAL | [NAME] | [NAME]
33890 | WIRRAL HOSPITAL | [NAME] | [NAME]
33945 | NOTTINGHAM UNI HOSPITAL NHS TRUST | [NAME] | [NAME]
34139 | WELLINGTON HOSPITAL | [NAME] | [NAME]
34147 | HOSPITAL OF ST JOHN & | [NAME] | [NAME]
34403 | YEW STREET CHESHIRE | [NAME] | [NAME]
34796 | NUFFIELD BRIGHTON | [NAME] | [NAME]
34972 | CLASSIC LOURDES | [NAME] | [NAME]
35123 | NUFFIELD NEWCASTLE HOSPITAL | [NAME] | [NAME]
35174 | NUFFIELD ACLAND HOME | [NAME] | [NAME]
35211 | RAMSAY FITZWILLIAM HOSPITAL | [NAME] | [NAME]
35342 | IBH KINGS PARK HPL | [NAME] | [NAME]
35449 | BMI SARUM ROAD HOSPITAL | [NAME] | [NAME]
35529 | MACCLESFIELD DIST GENERAL | [NAME] | [NAME]
35545 | PRINCESS ROYAL HOSP-TELFO | [NAME] | [NAME]
35609 | ROYAL BOURNEMOUTH GEN HPL | [NAME] | [NAME]
35668 | UNIVERSITY HOSPITAL OF NORTH DURHAM | [NAME] | [NAME]
35730 | YSBYTY GWYNEDD HOSPITAL | [NAME] | [NAME]
35756 | NORTHAMPTON GENERAL HOSPI | [NAME] | [NAME]
35764 | SALISBURY DISTRICT HOSPTL | [NAME] | [NAME]
35801 | HOPE HOSPITAL SALFORD | [NAME] | [NAME]
35879 | GARTNAVEL GENERAL HOSPITL | [NAME] | [NAME]
35991 | CITY HOSPITAL NHS TRUST | [NAME] | [NAME]
36011 | HEMEL HEMPSTEAD GENERAL | [NAME] | [NAME]
36038 | BARNSLEY DISTRICT GENERAL | [NAME] | [NAME]
36062 | WHITTINGTON HOSPITAL | [NAME] | [NAME]
36071 | UNIVERSITY COLLEGE HPL | [NAME] | [NAME]
36126 | TAUNTON & SOMERSET HOSP | [NAME] | [NAME]
36134 | BRIDG | [NAME] | [NAME]
36134 | PRINCESS OF WALES HOSPITAL BRIDGEND | [NAME] | [NAME]
36142 | CHORLEY & DISTRICT HPL | [NAME] | [NAME]
36151 | [NAME] | [NAME] | [NAME]
36214 | LEWISHAM HOSPITAL | [NAME] | [NAME]
36249 | UNIVERSITY HOSPITAL OF WALES CARDIFF | [NAME] | [NAME]
36337 | CHESTERFIELD ROYAL HOSP | [NAME] | [NAME]
36353 | POOLE GENERAL HOSPITAL | [NAME] | [NAME]
36361 | LUTON & DUNSTABLE HOSP | [NAME] | [NAME]
36425 | QUEEN ELIZABETH HOSPITAL | [NAME] | [NAME]
36468 | ST GEORGES HOSPITAL-LOND | [NAME] | [NAME]
36484 | AIREDALE GENERAL HOSPITAL | [NAME] | [NAME]
36492 | BRISTOL ROYAL INFIRMARY | [NAME] | [NAME]
36548 | BRADFORD [NAME] | [NAME] | [NAME]
36564 | VICTORIA INFIRMARY | [NAME] | [NAME]
36581 | [NAME] | [NAME] | [NAME]
36636 | QUEEN [NAME] (SIDCUP) | [NAME] | [NAME]
36644 | CHASE FARM HOSPITAL | [NAME] | [NAME]
36741 | NUFFIELD CHELTENHAM & GLOUCESTER HOSP | [NAME] | [NAME]
36812 | WORTHING HOSPITAL | [NAME] | [NAME]
36871 | [NAME] | [NAME] | [NAME]
37305 | KINGS COLLEGE HOSPITAL LONDON | [NAME] | [NAME]
37495 | PRINCESS ELIZABETH HOSP ST MARTIN | [NAME] | [NAME]
37680 | NORTH HAMPSHIRE HOSPITAL | [NAME] | [NAME]
38236 | LLANDOUGH HOSPITAL | [NAME] | [NAME]
38261 | FREEMAN HOSPITAL | [NAME] | [NAME]
38316 | EAST SURREY HOSPITAL | [NAME] | [NAME]
38383 | NORTH TYNESIDE GENERAL | [NAME] | [NAME]
38391 | WANSBECK GENERAL HPL | [NAME] | [NAME]
38404 | SHEFFIELD CHILDREN'S HOSP | [NAME] | [NAME]
38501 | UNIVERSITY COLLEGE HOSPITAL LONDON | [NAME] | [NAME]
38551 | SPIRE WELLESLEY HOSP | [NAME] | [NAME]
38631 | SPIRE PORTSMOUTH HAVANT | [NAME] | [NAME]
38826 | AINTREE HOSPITAL NHS | [NAME] | [NAME]
39124 | FURNESS GENERAL HOSPITAL | [NAME] | [NAME]
39298 | SOUTHPORT DIST GEN HOSP | [NAME] | [NAME]
39319 | DR GRAYS HOSPITAL | [NAME] | [NAME]
39343 | FRENCHAY HOSPITAL | [NAME] | [NAME]
39360 | SOUTHMEAD GENERAL HOSPITA | [NAME] | [NAME]
41515 | NEATH & PORT TALBOT HOSPITAL | [NAME] | [NAME]
41523 | ROYAL LONDON HOSPITAL | [NAME] | [NAME]
41603 | AYR HOSPITAL | [NAME] | [NAME]
41662 | CROSSHOUSE HOSPITAL | [NAME] | [NAME]
41873 | ST PETER'S HOSPITAL | [NAME] | [NAME]
41890 | ASHFORD HOSPITAL | [NAME] | [NAME]
42041 | ROYAL GWENT HOSPITAL | [NAME] | [NAME]
42067 | ST HELIER HOSPITAL | [NAME] | [NAME]
42104 | EPSOM GENERAL HOSPITAL | [NAME] | [NAME]
42139 | CANNOCK CHASE HOSPITAL | [NAME] | [NAME]
42147 | MORRISTON HOSPITAL SWANSEA | [NAME] | [NAME]
42227 | [NAME] | [NAME] | [NAME]
42243 | ROYAL GLAMORGAN HOSPITAL | [NAME] | [NAME]
42278 | GUYS HOSPITAL | [NAME] | [NAME]
42340 | DIANA PRINCESS OF WALES HOSPITAL GRIMSBY | [NAME] | [NAME]
42374 | NORFOLK & NORWICH HOSP. | [NAME] | [NAME]
49841 | [NAME] | [NAME] | [NAME]
60020 | UNIVERSITY HOSPITAL COVENTRY COVENTRY | [NAME] | [NAME]
603400 | S/W LONDON ELECTIVE ORTHOPAEDIC CENTRE SURREY | [NAME] | [NAME]
60370 | GLAN CLWYD HOSPITAL | [NAME] | [NAME]
60548 | QUEEN [NAME] THE QUEEN | [NAME] | [NAME]
60927 | STRACATHRO HOSPITAL | [NAME] | [NAME]
61225 | DARENT VALLEY HOSPITAL | [NAME] | [NAME]
61815 | CLAREMONT HOSPITAL | [NAME] | [NAME]
62252 | WRIGHTINGTON HOSPITAL | [NAME] | [NAME]
62279 | [NAME] | [NAME] | [NAME]
62332 | CLASSIC REGENCY HOSPITAL | [NAME] | [NAME]
63167 | ROYAL LIVERPOOL HOSPITAL | [NAME] | [NAME]
63175 | BROADGREEN HOSPITAL | [NAME] | [NAME]
63263 | BMI WOODLANDS HOSPITAL | [NAME] | [NAME]
63319 | QUEEN [NAME] HOSP | [NAME] | [NAME]
636455 | ILKESTON COMMUNITY HOSPITAL DERBY | [NAME] | [NAME]
63829 | CAERPHILLY MINERS HOSP | [NAME] | [NAME]