Spreadsheet: 750738d1633614667-how-to-add-new-column-with-vlookup-formula-in-powerquery-connection-pq-vlookup-aligw
Sheet: Source Data

First Name | Surname | Age | 1st line of address | Town |  | First Name | Surname | Age | 1st line of address | Town | Postcode
First name 1 | Surname 1 | 22 | Address 1 | Town 1 |  | First name 1 | Surname 1 | 22 | Address 1 | Town 1 | Post code 1
First name 2 | Surname 2 | 45 | Address 2 | Town 2 |  | First name 11 | Surname 11 | 42 | Address 11 | Town 1 | Post code 1
First name 3 | Surname 3 | 65 | Address 3 | Town 3 |  | First name 2 | Surname 2 | 45 | Address 2 | Town 2 | Post code 2
First name 4 | Surname 4 | 11 | Address 4 | Town 4 |  | First name 12 | Surname 12 | 24 | Address 12 | Town 2 | Post code 2
First name 5 | Surname 5 | 13 | Address 5 | Town 5 |  | First name 3 | Surname 3 | 65 | Address 3 | Town 3 | Post code 3
First name 6 | Surname 6 | 15 | Address 6 | Town 6 |  | First name 4 | Surname 4 | 11 | Address 4 | Town 4 | Post code 4
First name 7 | Surname 7 | 24 | Address 7 | Town 7 |  | First name 5 | Surname 5 | 13 | Address 5 | Town 5 | Post code 5
First name 8 | Surname 8 | 26 | Address 8 | Town 8 |  | First name 6 | Surname 6 | 15 | Address 6 | Town 6 | Post code 6
First name 9 | Surname 9 | 32 | Address 9 | Town 9 |  | First name 7 | Surname 7 | 24 | Address 7 | Town 7 | Post code 7
First name 10 | Surname 10 | 38 | Address 10 | Town 10 |  | First name 8 | Surname 8 | 26 | Address 8 | Town 8 | Post code 8
First name 11 | Surname 11 | 42 | Address 11 | Town 1 |  | First name 9 | Surname 9 | 32 | Address 9 | Town 9 | Post code 9
First name 12 | Surname 12 | 24 | Address 12 | Town 2 |  | First name 10 | Surname 10 | 38 | Address 10 | Town 10 | Post code 10
First name 13 | Surname 13 | 47 | Address 13 | Town 3 |  | First name 13 | Surname 13 | 47 | Address 13 | Town 3 | Post code 3
First name 14 | Surname 14 | 67 | Address 14 | Town 4 |  | First name 14 | Surname 14 | 67 | Address 14 | Town 4 | Post code 4
First name 15 | Surname 15 | 13 | Address 15 | Town 5 |  | First name 15 | Surname 15 | 13 | Address 15 | Town 5 | Post code 5
First name 16 | Surname 16 | 15 | Address 16 | Town 6 |  | First name 16 | Surname 16 | 15 | Address 16 | Town 6 | Post code 6
First name 17 | Surname 17 | 17 | Address 17 | Town 7 |  | First name 17 | Surname 17 | 17 | Address 17 | Town 7 | Post code 7
First name 18 | Surname 18 | 26 | Address 18 | Town 8 |  | First name 18 | Surname 18 | 26 | Address 18 | Town 8 | Post code 8
First name 19 | Surname 19 | 28 | Address 19 | Town 9 |  | First name 19 | Surname 19 | 28 | Address 19 | Town 9 | Post code 9
First name 20 | Surname 20 | 34 | Address 20 | Town 10 |  | First name 20 | Surname 20 | 34 | Address 20 | Town 10 | Post code 10
First name 21 | Surname 21 | 40 | Address 21 | Town 7 |  | First name 21 | Surname 21 | 40 | Address 21 | Town 7 | Post code 7
First name 22 | Surname 22 | 44 | Address 22 | Town 8 |  | First name 22 | Surname 22 | 44 | Address 22 | Town 8 | Post code 8
First name 23 | Surname 23 | 26 | Address 23 | Town 9 |  | First name 23 | Surname 23 | 26 | Address 23 | Town 9 | Post code 9
First name 24 | Surname 24 | 49 | Address 24 | Town 10 |  | First name 24 | Surname 24 | 49 | Address 24 | Town 10 | Post code 10
First name 25 | Surname 25 | 69 | Address 25 | Town 1 |  | First name 25 | Surname 25 | 69 | Address 25 | Town 1 | Post code 1
First name 26 | Surname 26 | 15 | Address 26 | Town 2 |  | First name 26 | Surname 26 | 15 | Address 26 | Town 2 | Post code 2
First name 27 | Surname 27 | 26 | Address 27 | Town 3 |  | First name 27 | Surname 27 | 26 | Address 27 | Town 3 | Post code 3
First name 28 | Surname 28 | 32 | Address 28 | Town 4 |  | First name 28 | Surname 28 | 32 | Address 28 | Town 4 | Post code 4
First name 29 | Surname 29 | 38 | Address 29 | Town 7 |  | First name 29 | Surname 29 | 38 | Address 29 | Town 7 | Post code 7
First name 30 | Surname 30 | 42 | Address 30 | Town 8 |  | First name 30 | Surname 30 | 42 | Address 30 | Town 8 | Post code 8
First name 31 | Surname 31 | 36 | Address 31 | Town 9 |  | First name 31 | Surname 31 | 36 | Address 31 | Town 9 | Post code 9
First name 32 | Surname 32 | 42 | Address 32 | Town 10 |  | First name 32 | Surname 32 | 42 | Address 32 | Town 10 | Post code 10
First name 33 | Surname 33 | 46 | Address 33 | Town 1 |  | First name 33 | Surname 33 | 46 | Address 33 | Town 1 | Post code 1
First name 34 | Surname 34 | 28 | Address 34 | Town 2 |  | First name 34 | Surname 34 | 28 | Address 34 | Town 2 | Post code 2
First name 35 | Surname 35 | 51 | Address 35 | Town 3 |  | First name 35 | Surname 35 | 51 | Address 35 | Town 3 | Post code 3
First name 36 | Surname 36 | 71 | Address 36 | Town 4 |  | First name 36 | Surname 36 | 71 | Address 36 | Town 4 | Post code 4
First name 37 | Surname 37 | 17 | Address 37 | Town 5 |  | First name 37 | Surname 37 | 17 | Address 37 | Town 5 | Post code 5
First name 38 | Surname 38 | 28 | Address 38 | Town 6 |  | First name 38 | Surname 38 | 28 | Address 38 | Town 6 | Post code 6
First name 39 | Surname 39 | 34 | Address 39 | Town 7 |  | First name 39 | Surname 39 | 34 | Address 39 | Town 7 | Post code 7
First name 40 | Surname 40 | 40 | Address 40 | Town 8 |  | First name 40 | Surname 40 | 40 | Address 40 | Town 8 | Post code 8
First name 41 | Surname 41 | 44 | Address 41 | Town 9 |  | First name 41 | Surname 41 | 44 | Address 41 | Town 9 | Post code 9