Spreadsheet: 889043d1739717895-vlookup-not-calculating-correctly-vlookup_excel_cois-etaf
Sheet: From another sheet

 |  |  | [NAME] |  |  | [NAME]
 | 1 | ABDEGAR SACRAMENTO |  |  |  |  |  |  |  | ANDRE ANTONIO | 45586 |  | 1
 | 2 | ABRAAO CANGUANGUA |  |  |  |  |  |  |  | [NAME] | 45588 |  | 1
 | 3 | ADAO MAVUNGO |  |  |  |  |  |  |  | JOAO CABRAL | 45588 |  | 1
 | 4 | AFONSO NARCISCO |  |  |  |  |  |  |  | ABDEGAR SACRAMENTO | 45589 |  | 1
 | 5 | [NAME] |  |  |  |  |  |  |  | [NAME] | 45590 |  | 1
 | 6 | ALLAN BREDENKAMP |  |  |  |  |  |  |  | FRANCOIS SWART | 45598 | 2 | 1
 | 7 | AMERICO NETO |  |  |  |  |  |  |  | [NAME] | 45603 |  | 1
 | 8 | ANDRE ANTONIO |  |  |  |  |  |  |  | ISAAC NDONGA | 45605 |  | 1
 | 9 | [NAME] |  |  |  |  |  |  |  | [NAME] | 45605 |  | 1
 | 10 | [NAME] |  |  |  |  |  |  |  | [NAME] | 45630 |  | 1
 | 11 | ANTONIO MATUVANGA |  |  |  |  |  |  |  | [NAME] | 45630 |  | 1
 | 12 | ARAO SAMUEL |  |  |  |  |  |  |  | [NAME] | 45630 |  | 1
 | 13 | AUGUSTO JOAO |  |  |  |  |  |  |  | QUIBILA PANDA | 45631 |  | 1
 | 14 | AVELINO KATEKWA |  |  |  |  |  |  |  | [NAME] | 45631 |  | 1
 | 15 | AVELINO RUFINO |  |  |  |  |  |  |  | [NAME] | 45631 |  | 1
 | 16 | BALO MATEUS |  |  |  |  |  |  |  | BERNADO GIME | 45640 |  | 1
 | 17 | BANGANGA MACONDA |  |  |  |  |  |  |  | JOAO CABRAL | 45645 |  | 1
 | 18 | BUMBA LOURENCO |  |  |  |  |  |  |  | GREGORIO PITULA | 45659 |  | 1
 | 19 | CHELA JOAO |  |  |  |  |  |  |  | MOSES MEPHI | 45693 |  | 1
 | 20 | DA COSTA YANNICK |  |  |  |  |  |  |  | CARLOS WALTER AFONSO | 45693 |  | 1
 | 21 | DANIEL DOMINGOS |  |  |  |  |  |  |  | PEDRO JUSTINO | 45695 |  | 1
 | 22 | [NAME] |  |  |  |  |  |  |  | RODRIGO RODRIGUES | 45696 |  | 1
 | 23 | EDUARDO DA SILVA
 | 24 | ELIAS TIAGO
 | 25 | [NAME]
 | 26 | [NAME]
 | 27 | FRANCISCO BANDUMBA
 | 28 | FRANCOIS SWART
 | 29 | FREDERICO MUEDI
 | 30 | GARCIA GERVASIO
 | 31 | GERMINO POBA
 | 32 | GIMBI LUCIO
 | 33 | GIME BERNARDO
 | 34 | ISAAC MARIA
 | 35 | ISAAC NDONGA
 | 36 | [NAME]
 | 37 | JEREMIAS NDONGANI
 | 38 | JERONIMO BRAS
 | 39 | JOAO CABRAL
 | 40 | JOAO MARIA
 | 41 | JOAO NGUNZA
 | 42 | [NAME]
 | 43 | [NAME]
 | 44 | [NAME]
 | 45 | KIALA FABRICIO
 | 46 | KURT STOGER
 | 47 | LUCIANO JANEIRO
 | 48 | LUIS DA SILVA
 | 49 | MABUZA MALUSI
 | 50 | MALONDA PEDRO
 | 51 | MANUEL POMBOLO
 | 52 | MASIAMINA SIMÃO
 | 53 | [NAME]
 | 54 | MAVUNGO RAFAEL
 | 55 | [NAME]
 | 56 | MIGUEL KALAWAKU
 | 57 | MIGUEL TOKO ZASALA
 | 58 | MOSES MEPHI
 | 59 | [NAME]
 | 60 | NHEMBO PEDRO
 | 61 | NZINGA ALBERTO
 | 62 | OLIMPIO CESAR
 | 63 | OSVALDO JOSE
 | 64 | PAULINO BINDA
 | 65 | PAULO LUKIBI
 | 66 | PEDRITO GOMES SITA
 | 67 | PEDRO JUSTINO
 | 68 | [NAME]
 | 69 | QUIBILA PANDA
 | 70 | RAFAEL MATUNTA
 | 71 | RICHTER [NAME]
 | 72 | RODRIGO RODRIGUES
 | 73 | SAKHUMZI NGUBO
 | 74 | SAMI JLAIEL
 | 75 | SHANE VAN RENSBURG
 | 76 | [NAME]
 | 77 | TIAGO GOMA
 | 78 | TUMBA ALMEIDA
 | 79 | [NAME]
 | 80 | LUIS FRANQUE
 | 81 | JOAO CHELA
 | 82 | CARLOS WALTER AFONSO
 | 83 | LUIS JOSÉ
 | 84 | SHANE JANSE VAN RENSBURG
 | 85 | AFONSO NARCISCO
 | 86 | PEDRO MALUNDA
 | 87 | MIGUEL ZASALA
 | 88 | BERNADO GIME
 | 89 | MOISES MEPHI
 | 90 | PEDRO BINDA
 | 91 | ANTONIO MAVUNGO
 | 92 | PEDRITO SITA
 | 93 | PAULO CAPITA
 | 94 | RAMOS DA SILVA
 | 95 | BANGANGA MACONDA
 | 96 | GREGORIO PITULA
 | 97 | ALFREDO D SILVA
 | 98 | AfONSO NARCISCO
 | 99 | ELIAS TIAGO
 | 100 | AFONSO NARCISCO
 | 101 | [NAME]
 | 102 | CEDRIC TOTAL HSE
 | 103 | OIM
 | 104 | JAIME PASCOAL MARINE