Spreadsheet: 90829d1290545550-match-email-addresses-on-one-sheet-with-email-addresses-on-another-sheet-smwilson-vlookup-smallversion
Sheet: Sheet2

[NAME] | Company Category | Company | Title | First Name | Surname | Preferred Name | Initial | Job Title | 0 | 0 | 020 7638 9271 | 0 | 0 | Salisbury House | London Wall | 0 | 0 | London | EC2M 5PS | UK
[EMAIL] |  | Fake Company 2 |  | First 2 | Last 2 | Preferred 2 |  |  |  | [EMAIL] | 01234 5672 |  |  | Room PA107 | [NAME] | Glaisher Drive |  | Wolverhampton | WV10 9RU | UK
[EMAIL] | Law | Fake Company 3 | Mr | First 3 | Last 3 | Preferred 3 | J |  | LAW | [EMAIL] | 01234 5673 |  |  | Room PA107 | [NAME] | Glaisher Drive |  | Wolverhampton | WV10 9RU | UK
[EMAIL] | Law | Fake Company 6 | Miss | First 6 | Last 6 | Preferred 6 | M | Administrator |  | [EMAIL] | 01234 5676 |  |  | University Road | Highfield |  |  | Southampton | SP!7 1BJ | UK
[EMAIL] |  | Fake Company 9 | Mr | First 9 | Last 9 | Preferred 9 | D | Assistant [NAME] | LAW | [EMAIL] | 01234 5679 |  |  | PO Box 8 | [NAME] |  |  | Middlesbrough | TS5 4YU | UK
[EMAIL] |  | Fake Company 13 | Mr | First 13 | Last 13 | Preferred 13 | M |  |  | [EMAIL] | 01234 56713 |  |  | Free Word Centre | 60 Farringdon Road |  |  | London | EC1R 3RG | UK
[EMAIL] |  | Fake Company 23 | Mr | First 23 | Last 23 | Preferred 23 | J |  |  | [EMAIL] | 01234 56723 |  |  | 5000 Oxford Business Park South |  |  |  | Oxford | OX142BH | UK
[EMAIL] |  | Fake Company 31 | Miss | First 31 | Last 31 | Preferred 31 | J |  |  | [EMAIL] | 01234 56731 |  |  | 19-22 Rathbone Place |  |  |  | London | W1T 1HY | UK
[EMAIL] |  | Fake Company 32 | Miss | First 32 | Last 32 | Preferred 32 | J |  | LAW | [EMAIL] | 01234 56732 |  |  | 32b Parkstone Heights |  |  |  | Poole | BH14 0QF | UK
[EMAIL] |  | Fake Company 42 | Miss | First 42 | Last 42 | Preferred 42 | Y | Director & Print Evangelist |  | [EMAIL] | 01234 56742
[EMAIL] | Law | Fake Company 43 | Mr | First 43 | Last 43 | Preferred 43 | J | Deputy Purchasing Supplier | LAW | [EMAIL] | 01234 56743 |  |  | Fleet House | 8/12 New Bridge Street |  |  | London | EC4V 6AL
[EMAIL] |  | Fake Company 44 | Mr | First 44 | Last 44 | Preferred 44 | W |  |  | [EMAIL] | 01234 56744
[EMAIL] |  | Fake Company 52 | Miss | First 52 | Last 52 | Preferred 52 | M |  |  | [EMAIL] | 01234 56752 |  |  | 4 Woolgate Court |  |  | [NAME] | Norfolk
[EMAIL] |  | Fake Company 55 | Mr | First 55 | Last 55 | Preferred 55 | R |  |  | [EMAIL] | 01234 56755
[EMAIL] |  | Fake Company 59 | Miss | First 59 | Last 59 | Preferred 59 | T | Senior Work Experience Co-ordinator |  | [EMAIL] | 01234 56759
[EMAIL] |  | Fake Company 68 | Mr | First 68 | Last 68 | Preferred 68 | P | Procurement & Legal Services Manager |  | [EMAIL] | 01234 56768
[EMAIL] |  | Fake Company 68 | Mr | First 68 | Last 68 | Preferred 68 | P | Procurement & Legal Services Manager |  | [EMAIL] | 01234 56768
[EMAIL] | Law | Fake Company 73 | Mr | First 73 | Last 73 | Preferred 73 | A |  | LAW | [EMAIL] | 01234 56773 |  |  | Bankside | Hanborough Business Park | Long Hanborough |  | Oxfordshire | OX29 8LJ | UK
[EMAIL] |  | Fake Company 75 | Miss | First 75 | Last 75 | Preferred 75 | S |  |  | [EMAIL] | 01234 56775
[EMAIL] |  | Fake Company 78 | Mr | First 78 | Last 78 | Preferred 78 | A |  | LAW | [EMAIL] | 01234 56778 |  |  | 161-165 Farringdon Road |  |  |  | London | EC1R 3AL | UK
[EMAIL] |  | Fake Company 82 | Mr | First 82 | Last 82 | Preferred 82 | P | Communications Manager |  | [EMAIL] | 01234 56782
[EMAIL] |  | Fake Company 83 | Mr | First 83 | Last 83 | Preferred 83 | P | Retail Manager |  | [EMAIL] | 01234 56783
[EMAIL] |  | Fake Company 85 | Miss | First 85 | Last 85 | Preferred 85 | M |  |  | [EMAIL] | 01234 56785
[EMAIL] |  | Fake Company 99 | Mr | First 99 | Last 99 | Preferred 99 | F |  |  | [EMAIL] | 01234 56799