Spreadsheet: 273213d1382637088-vlookup-formula-problem-training-cost
Sheet: DATA

 |  | Employee 1 | Production Nights | Mnager 14a 1 | Attending on Day Off | 6.32
 |  | Employee 2 | Line 9 | Mnager 14a 2 | Attending on Day Off | 7.92
ADAM | SEARS | Employee 3 | Technical | Mnager 14a 3 | Attending on Day Off | 8.9
ADRIAN | [NAME] | Employee 4 | Technical | Mnager 14a 4 | Attending on Day Off | 8.19
ALEKSANDRS | JEFIMOVS-MIHJEVS | Employee 5 | Technical | Mnager 14a 5 | Attending on Day Off | 8.9
ALGIRDAS | JUSKEVICIUS | Employee 6 | Technical | Mnager 14a 6 | Attending on Day Off | 8.9
ALISA | SELUHAJEVA | Employee 7 | Technical | Mnager 14a 7 | Attending on Day Off | 7.92
ALVARO | PEREIRA NUNES | Employee 8 | Production Nights | Mnager 14a 8 | Attending on Day Off | 6.32
AMIR | [NAME] | Employee 9 | Hygiene days | Mnager 14a 9 | Attending on Day Off | 8.9
ANDREW | AMOS | Employee 10 | Production Nights | Mnager 14a 10 | Attending on Day Off | 7.92
ANDREW | GOSLING | Employee 11 | [NAME] | Mnager 14a 11 | Attending on Day Off | 8.9
ANDREW | KNIGHT | Employee 12 | [NAME] | Mnager 14a 12 | Attending on Day Off | 7.92
ANDREW | LANDER | Employee 13 | Production Nights | Mnager 14a 13 | Attending on Day Off | 6.32
ANDREW | [NAME] | Employee 14 | Technical | Mnager 14a 14 | Attending on Day Off | 7.92
ANDRIUS | GNIZINSKAS | Employee 15 | Line 9 | Mnager 14a 15 | Attending on Day Off | 7.92
ANN | WATSON | Employee 16 | Technical | Mnager 14a 16 | Attending on Day Off | 7.92
ANNA | SOKOLOVA | Employee 17 | Forklift Red | Mnager 14a 17 | Attending on Day Off | 8.39
ANNA | TULACZ | Employee 18 | Line 1 & 2 Blue | Mnager 14a 18 | Attending on Day Off | 7.28
ANTHONY | KNOWLES | Employee 19 | Forklift Red | Mnager 14a 19 | Attending on Day Off | 7.47
ANTONIO | SCHIAVONE | Employee 20 | Line 1 & 2 Blue | Mnager 14a 20 | Attending on Day Off | 6.32
APRIL | RICHARDSON | Employee 21 | Line 1 & 2 Blue | Mnager 14a 21 | Attending on Day Off | 6.8
ARNAS | PALIULIS | Employee 22 | Forklift Graders Red | Mnager 14a 22 | Attending on Day Off | 7.47
ARTURAS | SAAKIANAS | Employee 23 | Forklift Graders Red | Mnager 14a 23 | Attending on Day Off | 8.39
ASHLEIGH | BECKETT | Employee 24 | [NAME] | Mnager 14a 24 | Attending on Day Off | 7.72
AUDRIUS | LAPINSKAS | Employee 25 | Line 1 & 2 Blue | Mnager 14a 25 | Attending on Day Off | 7.92
AURIKA | BUTVILIENE | Employee 26 | Line 5a | Mnager 14a 26 | Attending on Day Off | 6.8
AWAL | [NAME] | Employee 27 | Forklift Graders Red | Mnager 14a 27 | Attending on Day Off | 9.37
[NAME] | PARTRIDGE | Employee 28 | Line 4 | Mnager 14a 28 | Attending on Day Off | 6.32
[NAME] | PEARSON | Employee 29 | Technical | Mnager 14a 29 | Attending on Day Off | 8.19
BERNARD | BLISS | Employee 30 | Hygiene nights | Mnager 14a 30 | Attending on Day Off | 7.51
BEV | GEDGE | Employee 31 | Organics | Mnager 14a 31 | Attending on Day Off | 6.8
BIRUTE | VALENTINAITE | Employee 32 | Organics | Mnager 14a 32 | Attending on Day Off | 7.92
BISMILAH | JAN | Employee 33 | [NAME] | Mnager 14a 33 | Attending on Day Off | 8.9
CAROL | HAYES | Employee 34 | Forklift Blue | Mnager 14a 34 | Attending on Day Off | 8.39
CAROL | WESTERN | Employee 35 | [NAME] | Mnager 14a 35 | Attending on Day Off | 7.92
CAROLINE | SMITH | Employee 36 | Line 9 | Mnager 14a 36 | Attending on Day Off | 6.32
CHRISTINE | HUCKLE | Employee 37 | Production Nights | Mnager 14a 37 | Attending on Day Off | 8.39
CHRISTOPHER | BURKE | Employee 38 | Forklifts Days | Mnager 14a 38 | Attending on Day Off | 7.47
CHRISTOPHER | TOMPKINS | Employee 39 | Line 3 | Mnager 14a 39 | Attending on Day Off | 7.92
CLARE | BECKETT | Employee 40 | Line 4 | Mnager 14a 40 | Attending on Day Off | 6.32
COLIN | GRAY | Employee 41 | [NAME] | Mnager 14a 41 | Attending on Day Off | 7.92
COLIN | YOULES | Employee 42 | Line 5a | Mnager 14a 42 | Attending on Day Off | 6.38
CRAIG | MORLEY | Employee 43 | Line 4 | Mnager 14a 43 | Attending on Day Off | 7.92
CRISTIANO | PEREIRA | Employee 44 | Technical | Mnager 14a 44 | Attending on Day Off | 7.92
DAINIUS | MAZUKNA | Employee 45 | Line 4 | Mnager 14a 45 | Attending on Day Off | 6.8
DANIEL | GOSLING | Employee 46 | Line 1 & 2 Red | Mnager 14a 46 | Attending on Day Off | 8.39
DARREN | GREEN | Employee 47 | Forklift Red | Mnager 14a 47 | Attending on Day Off | 8.39
[NAME] | CROFTS | Employee 48 | Forklift Red | Mnager 14a 48 | Attending on Day Off | 8.39
[NAME] | HAYNES | Employee 49 | Line 1 & 2 Blue | Mnager 14a 49 | Attending on Day Off | 6.32
[NAME] | [NAME] | Employee 50 | Line 5a | Mnager 14a 50 | Attending on Day Off | 7.92
[NAME] | STUBBLES | Employee 51 | Line 4 | Mnager 14a 51 | Attending on Day Off | 6.8
DEAN | FORWAY | Employee 52 | Line 1 & 2 Blue | Mnager 14a 52 | Attending on Day Off | 6.32
[NAME] | WATSON | Employee 53 | Production Nights | Mnager 14a 53 | Attending on Day Off | 7.92
[NAME] | HARPER | Employee 54 | Despatch Shift | Mnager 14a 54 | Attending on Day Off | 7.92
EDWARD | STRINGER | Employee 55 | Line 9 | Mnager 14a 55 | Attending on Day Off | 7.92
ELAINE | RICHARDSON | Employee 56 | Line 1 & 2 Red | Mnager 14a 56 | Attending on Day Off | 7.92
ELISABETH | WATSON | Employee 57 | Line 1 & 2 Blue | Mnager 14a 57 | Attending on Day Off | 6.32
FRAIDON | SHAHPASANDI | Employee 58 | Technical | Mnager 14a 58 | Attending on Day Off | 7.92
GARETH | JONES | Employee 59 | Line 4 | Mnager 14a 59 | Attending on Day Off | 8.9
GRAHAM | HORGAN | Employee 60 | Line 1 & 2 Blue | Mnager 14a 60 | Attending on Day Off | 7.92
HANNAH | [NAME] | Employee 61 | Line 1 & 2 Blue | Mnager 14a 61 | Attending on Day Off | 6.8
HELEN | BECKETT | Employee 62 | Line 1 & 2 Blue | Mnager 14a 62 | Attending on Day Off | 8.9
IGORS | VASILJEVS | Employee 63 | Line 5a | Mnager 14a 63 | Attending on Day Off | 8.4
JACKIE | KYNASTON | Employee 64 | Line 5a | Mnager 14a 64 | Attending on Day Off | 7.92
JACQUELINE | MELLOR | Employee 65 | Line 3 | Mnager 14a 65 | Attending on Day Off | 6.32
[NAME] | LAKE | Employee 66 | Line 5a | Mnager 14a 66 | Attending on Day Off | 8.4
[NAME] | YEAGERS | Employee 67 | Line 8 | Mnager 14a 67 | Attending on Day Off | 7.92
[NAME] | WILDING | Employee 68 | Line 7 | Mnager 14a 68 | Attending on Day Off | 8.9
[NAME] | [NAME] | Employee 69 | Engineering | Mnager 14a 69 | Attending on Day Off | 11
JANINA | STONIENE | Employee 70 | Forklift Graders Blue | Mnager 14a 70 | Attending on Day Off | 8.39
JASON | NEEDHAM | Employee 71 | Production Nights | Mnager 14a 71 | Attending on Day Off | 6.32
JEAN | GUTTERIDGE | Employee 72 | Line 5a | Mnager 14a 72 | Attending on Day Off | 8.4
JELENA | PERSIKOVA-KULKEVICA | Employee 73 | Line 9 | Mnager 14a 73 | Attending on Day Off | 6.38
[NAME] | KRAWCZYK | Employee 74 | [NAME] | Mnager 14a 74 | Attending on Day Off | 8.9
JOAQUIM | CARDOSO | Employee 75 | [NAME] | Mnager 14a 75 | Attending on Day Off | 8.9
JON | KYNASTON | Employee 76 | Despatch Shift | Mnager 14a 76 | Attending on Day Off | 8.9
JULIE | BRAND | Employee 77 | Line 1 & 2 Blue | Mnager 14a 77 | Attending on Day Off | 6.32
JULIE | BRISCOE | Employee 78 | Forklift Graders Red | Mnager 14a 78 | Attending on Day Off | 9.37
JURGITA | ENDRIJAITYE | Employee 79 | Production Nights | Mnager 14a 79 | Attending on Day Off | 8.4
[NAME] | ADAMS | Employee 80 | Forklift Graders Blue | Mnager 14a 80 | Attending on Day Off | 8.39
[NAME] | HILLS | Employee 81 | Line 1 & 2 Blue | Mnager 14a 81 | Attending on Day Off | 6.32
KEVIN | GREEN | Employee 82 | Despatch Shift | Mnager 14a 82 | Attending on Day Off | 7.92
KRISTINA | RAZONAITE | Employee 83 | Line 3 | Mnager 14a 83 | Attending on Day Off | 6.32
KRZYSZTOF | WYWROT | Employee 84 | Despatch Shift | Mnager 14a 84 | Attending on Day Off | 7.92
KYLIE | BECKETT | Employee 85 | Line 7 | Mnager 14a 85 | Attending on Day Off | 6.8
LAURA | SEMETAITE | Employee 86 | [NAME] | Mnager 14a 86 | Attending on Day Off | 8.9
[NAME] | SAVICIUTE | Employee 87 | Organics | Mnager 14a 87 | Attending on Day Off | 8.39
LORRAINE | HILLS | Employee 88 | Forklift Blue | Mnager 14a 88 | Attending on Day Off | 8.39
LYNSEY | CROSS | Employee 89 | Forklift Graders Blue | Mnager 14a 89 | Attending on Day Off | 8.39
MANDY | TUFFEE | Employee 90 | Despatch Shift | Mnager 14a 90 | Attending on Day Off | 9.37
MANUEL | SOUSA | Employee 91 | [NAME] | Mnager 14a 91 | Attending on Day Off | 7.72
MARGARET ELLEN | [NAME] | Employee 92 | Production Nights | Mnager 14a 92 | Attending on Day Off | 10.47
MARK | McELDUFF | Employee 93 | Line 1 & 2 Blue | Mnager 14a 93 | Attending on Day Off | 7.92
MARK | PEARS | Employee 94 | Line 1 & 2 Red | Mnager 14a 94 | Attending on Day Off | 6.32
MARTIN | JACKSON-SKEELS | Employee 95 | Line 1 & 2 Red | Mnager 14a 95 | Attending on Day Off | 7.92
MATEUSZ | JAMROZIK | Employee 96 | Line 5a | Mnager 14a 96 | Attending on Day Off | 7.92
MATTHEW | GOODALL | Employee 97 | Forklifts Days | Mnager 14a 97 | Attending on Day Off | 8.19
[NAME] | BROCKMAN | Employee 98 | Line 5b | Mnager 14a 98 | Attending on Day Off | 7.92
MICHAL | ZAREBA | Employee 99 | Technical | Mnager 14a 99 | Attending on Day Off | 7.92
MUHAMEED | HAIDER | Employee 100 | Line 1 & 2 Red | Mnager 14a 100 | Attending on Day Off | 6.8
NATALJA | LUSNIKOVA | Employee 101 | Production Nights | Mnager 14a 101 | Attending on Day Off | 8.4
NIJOLE | JUSKEVICIENE | Employee 102 | Technical | Mnager 14a 102 | Attending on Day Off | 7.92
NUSRAT | AHMAD | Employee 103 | Forklift Graders Blue | Mnager 14a 103 | Attending on Day Off | 8.39
OJARS | STAVROUSKIS | Employee 104 | Line 4 | Mnager 14a 104 | Attending on Day Off | 7.92
OSKAR | PROLEJKO | Employee 105 | Printroom Blue | Mnager 14a 105 | Attending on Day Off | 6.8
PAUL | BLISS | Employee 106 | Technical | Mnager 14a 106 | Attending on Day Off | 7.92
PAUL | GEDGE | Employee 107 | Production Nights | Mnager 14a 107 | Attending on Day Off | 6.32
PAUL | McCABE | Employee 108 | Forklift Blue | Mnager 14a 108 | Attending on Day Off | 8.39
PAUL | WARNER | Employee 109 | [NAME] | Mnager 14a 109 | Attending on Day Off | 8.9
PAULINE | NORTON | Employee 110 | Despatch Shift | Mnager 14a 110 | Attending on Day Off | 7.92
RAIMONDAS | VINKSKA | Employee 111 | Line 7 | Mnager 14a 111 | Attending on Day Off | 6.8
RASA | KASILIAUSKIENE | Employee 112 | [NAME] | Mnager 14a 112 | Attending on Day Off | 8.9
[NAME] | ZVEGA | Employee 113 | Production Nights | Mnager 14a 113 | Attending on Day Off | 8.39
RICHARD | GREEN | Employee 114 | Despatch Shift | Mnager 14a 114 | Attending on Day Off | 7.92
[NAME] | PROCTOR | Employee 115 | Despatch Shift | Mnager 14a 115 | Attending on Day Off | 8.9
[NAME] | MASON | Employee 116 | Line 3 | Mnager 14a 116 | Attending on Day Off | 6.8
RONALD | MITCHELL | Employee 117 | Line 5a | Mnager 14a 117 | Attending on Day Off | 7.92
RONALD | WOOL | Employee 118 | Line 8 | Mnager 14a 118 | Attending on Day Off | 7.92
[NAME] | COPEMAN | Employee 119 | Production Nights | Mnager 14a 119 | Attending on Day Off | 7.92
RUI | PINTO | Employee 120 | Line 1 & 2 Red | Mnager 14a 120 | Attending on Day Off | 7.92
SAJJAD | ALI | Employee 121 | Line 1 & 2 Red | Mnager 14a 121 | Attending on Day Off | 6.8
SANDRA | WHINNETT | Employee 122 | Despatch Shift | Mnager 14a 122 | Attending on Day Off | 7.92
SHAUN | NAUGHTON | Employee 123 | Line 1 & 2 Blue | Mnager 14a 123 | Attending on Day Off | 6.8
SIMON | HAYNES | Employee 124 | Line 4 | Mnager 14a 124 | Attending on Day Off | 8.9
SOPHIE | HOWLETT | Employee 125 | Despatch Shift | Mnager 14a 125 | Attending on Day Off | 8.9
STEFAN | WOJTOWYOZ | Employee 126 | Forklift Red | Mnager 14a 126 | Attending on Day Off | 8.39
STEPHEN | [NAME] | Employee 127 | Packaging | Mnager 14a 127 | Attending on Day Off | 8.9
STEPHEN | GOODWIN | Employee 128 | Line 5a | Mnager 14a 128 | Attending on Day Off | 8.9
STUART | BUTLER | Employee 129 | Line 4 | Mnager 14a 129 | Attending on Day Off | 6.32
STUART | CURRIE | Employee 130 | Line 1 & 2 Red | Mnager 14a 130 | Attending on Day Off | 7.28
STUART | DEANE | Employee 131 | [NAME] | Mnager 14a 131 | Attending on Day Off | 7.92
STUART | FISHER | Employee 132 | Production Nights | Mnager 14a 132 | Attending on Day Off | 6.32
STUART | SMITH | Employee 133 | Forklift Blue | Mnager 14a 133 | Attending on Day Off | 8.39
SUSAN | WEBB | Employee 134 | Line 5a | Mnager 14a 134 | Attending on Day Off | 7.92
SVETLANA | BELECKIENE | Employee 135 | Line 5a | Mnager 14a 135 | Attending on Day Off | 8.4
TADAS | ZALESKAS | Employee 136 | Despatch Shift | Mnager 14a 136 | Attending on Day Off | 9.37
TATJANA | JERMOLAJEVA | Employee 137 | Production Nights | Mnager 14a 137 | Attending on Day Off | 6.32
THOMAS | MCGOWAN | Employee 138 | Line 1 & 2 Red | Mnager 14a 138 | Attending on Day Off | 7.92
TOMA | UFARTIENE | Employee 139 | Despatch Shift | Mnager 14a 139 | Attending on Day Off | 7.92
TOMAS | KAUNESCKAS | Employee 140 | Line 9 | Mnager 14a 140 | Attending on Day Off | 6.32
 |  | Employee 141 | Line 5a | Mnager 14a 141 | Attending on Day Off | 6.32
 |  |  |  |  | Agency Basic | 7.75
 |  |  |  |  | Agency Despatch | 10.53
 |  |  |  |  | Agency QC | 9.9
 |  |  |  |  | Agency Hygiene days | 9.99
 |  |  |  |  | Agency Night Fork Lift | 10.53
 |  |  |  |  | Agency Nights Hygiene | 10.45