Spreadsheet: 703572d1605058291-index-and-match-from-dropdown-only-returns-1st-value-training
Sheet: Data

 | No . | Name | HODs
 | 1 | Staff 1 | Manager 1
 | 2 | Staff 2 | Manager 1
 | 3 | Staff 3 | Manager 2
 | 4 | Staff 4 | Manager 2
 | 5 | Staff 5 | Manager 2
 | 6 | Staff 6 | Manager 2
 | 7 | Staff 7 | Manager 2
 | 8 | Staff 8 | Manager 2
 | 9 | Staff 9 | Manager 2
 | 10 | Staff 10 | Manager 2
 | 11 | Staff 11 | Manager 2
 | 12 | Staff 12 | Manager 2
 | 13 | Staff 13 | Manager 2
 | 14 | Staff 14 | Manager 2
 | 15 | Staff 15 | Manager 2
 | 16 | Staff 16 | Manager 2
 | 17 | Staff 17 | Manager 2
 | 18 | Staff 18 | Manager 2
 | 19 | Staff 19 | Manager 2
 | 20 | Staff 20 | Manager 2
 | 21 | Staff 21 | Manager 2
 | 22 | Staff 22 | Manager 3
 | 23 | Staff 23 | Manager 3
 | 24 | Staff 24 | Manager 3
 | 25 | Staff 25 | Manager 3
 | 26 | Staff 26 | Manager 3
 | 27 | Staff 27 | Manager 3
 | 28 | Staff 28 | Manager 3
 | 29 | Staff 29 | Manager 3
 | 30 | Staff 30 | Manager 3
 | 31 | Staff 31 | Manager 3
 | 32 | Staff 32 | Manager 3
 | 33 | Staff 33 | Manager 3
 | 34 | Staff 34 | Manager 3
 | 35 | Staff 35 | Manager 3
 | 36 | Staff 36 | Manager 3
 | 37 | Staff 37 | Manager 3
 | 38 | Staff 38 | Manager 4
 | 39 | Staff 39 | Manager 4
 | 40 | Staff 40 | Manager 4
 | 41 | Staff 41 | Manager 4
 | 42 | Staff 42 | Manager 4
 | 43 | Staff 43 | Manager 4
 | 44 | Staff 44 | Manager 4
 | 45 | Staff 45 | Manager 4
 | 46 | Staff 46 | Manager 4
 | 47 | Staff 47 | Manager 4
 | 48 | Staff 48 | Manager 4
 | 49 | Staff 49 | Manager 5
 | 50 | Staff 50 | Manager 5
 | 51 | Staff 51 | Manager 5
 | 52 | Staff 52 | Manager 5
 | 53 | Staff 53 | Manager 6
 | 54 | Staff 54 | Manager 6
 | 55 | Staff 55 | Manager 6
 | 56 | Staff 56 | Manager 6
 | 57 | Staff 57 | Manager 7
 | 58 | Staff 58 | Manager 7
 | 59 | Staff 59 | Manager 7
 | 60 | Staff 60 | Manager 7
 | 61 | Staff 61 | Manager 7
 | 62 | Staff 62 | Manager 7
 | 63 | Staff 63 | Manager 7
 | 64 | Staff 64 | Manager 7
 | 65 | Staff 65 | Manager 7
 | 66 | Staff 66 | Manager 7
 | 67 | Staff 67 | Manager 7
 | 68 | Staff 68 | Manager 7
 | 69 | Staff 69 | Manager 7
 | 70 | Staff 70 | Manager 7
 | 71 | Staff 71 | Manager 7
 | 72 | Staff 72 | Manager 7
 | 73 | Staff 73 | Manager 7
 | 74 | Staff 74 | Manager 7
 | 75 | Staff 75 | Manager 7
 | 76 | Staff 76 | Manager 7
 | 77 | Staff 77 | Manager 8
 | 78 | Staff 78 | Manager 8
 | 79 | Staff 79 | Manager 8
 | 80 | Staff 80 | Manager 8
 | 81 | Staff 81 | Manager 8
 | 82 | Staff 82 | Manager 8
 | 83 | Staff 83 | Manager 8
 | 84 | Staff 84 | Manager 8
 | 85 | Staff 85 | Manager 9
 | 86 | Staff 86 | Manager 9
 | 87 | Staff 87 | Manager 9
 | 88 | Staff 88 | Manager 9
 | 89 | Staff 89 | Manager 9
 | 90 | Staff 90 | Manager 9
 | 91 | Staff 91 | Manager 9
 | 92 | Staff 92 | Manager 9
 | 93 | Staff 93 | Manager 9
 | 94 | Staff 94 | Manager 10
 | 95 | Staff 95 | Manager 10
 | 96 | Staff 96 | Manager 10
 | 97 | Staff 97 | Manager 10
 | 98 | Staff 98 | Manager 10
 | 99 | Staff 99 | Manager 10
 | 100 | Staff 100 | Manager 10
 | 101 | Staff 101 | Manager 10
 | 102 | Staff 102 | Manager 10
 | 103 | Staff 103 | Manager 10
 | 104 | Staff 104 | Manager 10
 | 105 | Staff 105 | Manager 10
 | 106 | Staff 106 | Manager 10
 | 107 | Staff 107 | Manager 10
 | 108 | Staff 108 | Manager 10
 |  | HODs | GROUP
 |  | Manager 1 | Dept 1
 |  | Manager 2 | Dept 2
 |  | Manager 3 | Dept 3
 |  | Manager 4 | Dept 4
 |  | Manager 5 | Dept 5
 |  | Manager 6 | Dept 6
 |  | Manager 7 | Dept 7
 |  | Manager 8 | Dept 8