Spreadsheet: 837320d1690041126-excel-exercises-excel-exercise-1
Sheet: Part 2

Part 2 - employee details
 |  |  |  |  |  |  | Question 4
 | This table contains a list of employee details and which site |  |  |  |  |  |  | Can you please use a VLOOKUP formula to find the following employees' full names?
 | number they work at.
 |  | DATA TABLE |  |  |  |  |  | Employee number | Full name
 | Employee number | First name | Surname | Site Code |  |  |  | 40466348
 | 97830636 | Maria | Hong | 6 |  |  |  | 85481693
 | 23078139 | [NAME] | Holzman | 11 |  |  |  | 23149866
 | 51030055 | Mark | Holtz | 7 |  |  |  | 98185856
 | 10444537 | [NAME] | [NAME] | 1 |  |  |  | 11341257
 | 79495697 | Martina | Hofstee | 11
 | 88097534 | Martinez | Hofman | 5
 | 65504434 | Masayoshi | [NAME] | 6 |  |  | Question 5
 | 16393749 | Massimo | Himmelfarb | 16 |  |  |  | Using the data tables from both part 1 and 2, please can you find the number of staff employeed in each region?
 | 17140156 | [NAME] | [NAME] | 13
 | 54130235 | [NAME] | Hagiwara | 21 |  |  |  | Location | # Employees
 | 93440625 | [NAME] | Hanan | 19 |  |  |  | London
 | 52646624 | [NAME] | Hawkins | 16 |  |  |  | South East
 | 19997079 | [NAME] | Hersom | 8 |  |  |  | Midlands
 | 53099177 | [NAME] | [NAME] | 2 |  |  |  | North East
 | 40466348 | Maxwell | Ha | 6 |  |  |  | South West
 | 94292837 | [NAME] | Guerra | 12 |  |  |  | Total
 | 38323713 | [NAME] | [NAME] | 1
 | 28233973 | [NAME] | [NAME] | 8
 | 90452788 | [NAME] | [NAME] | 19
 | 22612408 | Michelle | Grusq | 12
 | 75176391 | [NAME] | Grobe | 3
 | 39663023 | Mohammed | [NAME] | 20
 | 16618037 | Mohtadi | Greer | 7
 | 64852435 | Montero | Greene | 9
 | 44777963 | Muge | Graves | 13
 | 40686107 | [NAME] | Goto | 11
 | 92173416 | Nashat | Goswamy | 6
 | 19892860 | [NAME] | [NAME] | 21
 | 77605215 | Nathan | Gibb | 19
 | 23331670 | Nawaz | Georges | 12
 | 25157254 | Negrin | Gee | 5
 | 47582374 | Neto | Gautier | 20
 | 14614370 | [NAME] | Gautam | 17
 | 98507459 | Nicole | [NAME] | 9
 | 34482264 | Nishant | [NAME] | 19
 | 76863879 | [NAME] | [NAME] | 1
 | 64264892 | Noelle | Fu | 5
 | 73541347 | Obaid | Friis | 5
 | 50547234 | Ophir | Friedman | 16
 | 40886994 | [NAME] | Franzoni | 20
 | 96605338 | Pallavi | Fox | 20
 | 20809801 | Patino | [NAME] | 4
 | 72549390 | [NAME] | Fixler | 13
 | 50952225 | [NAME] | Flegal | 12
 | 10905970 | [NAME] | Figueiredo | 1
 | 10140189 | [NAME] | Elia | 10
 | 41614106 | [NAME] | Erickson | 2
 | 46485523 | [NAME] | Espinosa | 16
 | 85481693 | [NAME] | Ferrero | 4
 | 88753064 | [NAME] | [NAME] | 17
 | 88445793 | [NAME] | [NAME] | 1
 | 88924416 | Phill | Doyle | 19
 | 18418228 | Preston | Doorey | 11
 | 18175126 | Radu | Donahue | 16
 | 14645853 | Rahul | Dickstein | 0
 | 77162530 | Remy | Deomampo | 8
 | 73729221 | [NAME] | [NAME] | 12
 | 25553648 | [NAME] | Del | 7
 | 98185856 | [NAME] | [NAME] | 7
 | 81683063 | [NAME] | Crunelle | 16
 | 85921410 | [NAME] | Cruse | 7
 | 49608849 | [NAME] | [NAME] | 19
 | 50881629 | [NAME] | Dahmubed | 20
 | 23883535 | [NAME] | [NAME] | 1
 | 15104740 | [NAME] | Davidowitz | 6
 | 80009701 | Rodriguez | Crabtree | 11
 | 28574709 | [NAME] | Cooney | 16
 | 76002839 | [NAME] | Coyle | 11
 | 54912347 | Rui | Cockle | 2
 | 32724860 | [NAME] | Cloke | 12
 | 23402676 | Sachie | [NAME] | 19
 | 45149540 | Saeed | Cilento | 5
 | 36592432 | Salas | Chung | 16
 | 89181230 | Samaneh | [NAME] | 2
 | 46501691 | Samantha | [NAME] | 15
 | 58887750 | Sangjo | [NAME] | 10
 | 89096464 | Sara | Chomitz | 12
 | 25701345 | [NAME] | [NAME] | 9
 | 75479554 | Satiya | Cheung | 9
 | 77688493 | Scott | [NAME] | 8
 | 72238735 | Scott | [NAME] | 7
 | 21625550 | Shannon | Cheesebro | 13
 | 77578114 | Shiv | [NAME] | 18
 | 46771100 | [NAME] | Chau | 12
 | 87171279 | Simond | Chat | 6
 | 50182058 | [NAME] | [NAME] | 9
 | 73262167 | Stephen | [NAME] | 10
 | 39750661 | Stuti | Cha | 2
 | 93398138 | [NAME] | Cautero | 20
 | 49389930 | Sung | Casasayas | 7
 | 39097347 | Tadamitsu | Carrow | 6
 | 23149866 | Tae | Carrillo | 6
 | 64321431 | Tanzeer | Cao | 16
 | 26724299 | Tara | Cantrock | 7
 | 71294796 | Taryn | Canal | 10
 | 78984033 | [NAME] | Buckley | 12
 | 39336395 | [NAME] | [NAME] | 4
 | 73012068 | Thavin | [NAME] | 5
 | 51160630 | Theodore | [NAME] | 18
 | 13697816 | [NAME] | Brandt | 19
 | 54865739 | [NAME] | Braun | 16
 | 22684527 | [NAME] | Bosson | 20
 | 59014625 | Timothy | [NAME] | 3
 | 15253372 | Tobias | Blattman | 9
 | 37487742 | Trent | Blakely | 2
 | 28400801 | Uros | [NAME] | 11
 | 89782150 | Valle | Berkman | 17
 | 97907228 | Viacheslav | Benchimol | 12
 | 81354942 | Vivek | Beistegui | 19
 | 42867949 | Wayne | Bechrakis | 11
 | 12823452 | Wei | [NAME] | 12
 | 41901187 | [NAME] | [NAME] | 3
 | 11341257 | [NAME] | Baxter | 12
 | 19129758 | Won | Barakat | 6
 | 42559774 | Won | Barnes | 11
 | 84192594 | Wushen | Banovac | 5
 | 28133364 | [NAME] | Bala | 6
 | 10209599 | [NAME] | Bagdat | 2
 | 43845281 | Yan | [NAME] | 20
 | 95469450 | [NAME] | Aurori | 12
 | 12497778 | Yasuhiro | Au | 9
 | 58019519 | [NAME] | Atri | 6
 | 47597183 | [NAME] | Ashkenazi | 6
 | 52440929 | Yi | Aramendia | 3
 | 64807655 | [NAME] | [NAME] | 14
 | 95606679 | Ying | Altmann | 13
 | 97129453 | [NAME] | Alter | 7
 | 75506956 | Yi-Shiuan | Alsamdan | 13
 | 83127600 | Yookyung | [NAME] | 2
 | 51438247 | Yoon | Akin-Aderibigbe | 18
 | 30211204 | [NAME] | Ahn | 4
 | 33805097 | Yunzhe | Afonso | 5
 | 11624931 | Zhanetta | Adeyeye | 2
 | 30338301 | Zhen | [NAME] | 19
 | 19739511 | Zorina | Abreu | 12