Spreadsheet: 77759d1278230484-excel-2007-lookup-across-multiple-sheets-forum-eample
Sheet: Food Technology

 |  | First Name | LSBF ID | Food Technology |  |  |  |  |  |  |  |  | Comments
email
 |  |  |  | Cwrk |  |  | Exam |  |  | Total | Grade
 |  |  |  | 1st Mark | 2nd Mark | 0.8 | 1st Mark | 2nd Mark | 0.2 | 1
 | 1 | A S M Shamshear | 1233 | 45 |  | 45 | 41 |  | 41
 | 3 | [NAME] | 2444 | 5 | 5 | 5 | 43 |  | 43
 | 4 | [NAME] | 67765 | 69 |  | 69 | 46 |  | 46
 | 5 | [NAME] | 54787 | 55 |  | 55 | 58 |  | 58
 | 6 | [NAME] | 4353 | 52 |  | 52 | 46 |  | 46
 | 7 | Aimal | 8797 | NS |  | NS | 39 | 40 | 40
 | 8 | Ajay | 345368 | NS | NS | NS | 42 |  | 42
 | 9 | [NAME] | 56754 | 64 |  | 64 | 44 | 44 | 44
 | 10 | [NAME] | 45658 | 51 |  | 51 | 29 |  | 29
 | 11 | Alberto | 7489 | 55 |  | 55 | 44 |  | 44
 | 12 | [NAME] | 98743 | 68 |  | 68 | 50 |  | 50
 | 13 | Alina | 54756 | 58 |  | 58 | 22 | 22 | 22
 | 14 | Almaz Binti | 765446 | 65 |  | 65 | 30 | 30 | 30
 | 15 | [NAME] | 65488 | 63 |  | 63 | 30 | 30 | 30
 | 16 | [NAME] | 64745 | 42 |  | 42 | 34 | 34 | 34
 | 17 | Amrit | 3567536 | NS | NS | NS | 19 | 19 | 19
 | 18 | Ana | 45624 | 74 | 74 | 74 | 54 |  | 54
 | 19 | Aneesh | 6573567 | 72 | 72 | 72 | 51 |  | 51
 | 20 | [NAME] | 23424 | 62 |  | 62 | 42 |  | 42
 | 21 | Arti | 2345235 | 46 |  | 46 | 40 |  | 40
 | 22 | Aruneem | 90887 | 56 |  | 56 | 41 |  | 41
 | 23 | Arvind Kumar | 3456 | NS | NS | NS | NS | NS | NS
 | 24 | [NAME] | 987789 | 56 |  | 56 | 27 | 27 | 27
 | 25 | Ashwin Kumar | 4563 | 61 |  | 61 | 32 | 32 | 32
 | 26 | Asif | 3456 | 66 |  | 66 | 41 | 41 | 41
 | 27 | Atish | 4567 | 56 |  | 56 | 40 |  | 40
 | 28 | [NAME] | 345698 | NS | NS | NS | 58 |  | 58
 | 29 | [NAME] | 87 | 72 | 72 | 72 | 18 | 18 | 18
 | 30 | Bahodir | 7896 | 63 |  | 63 | 36 | 36 | 36
 | 31 | [NAME] | 345345 | 64 |  | 64 | 39 |  | 39
 | 32 | [NAME] | 54643 | 56 |  | 56 | 32 | 32 | 32
 | 33 | Binguangyuan | 78 | 54 |  | 54 |  | 19 | 19
 | 34 | [NAME] | 90 | 65 |  | 65 | 55 |  | 55
 | 35 | [NAME] | 8908 | 59 |  | 59 | 38 | 40 | 40
 | 36 | Bulat | 90 | 52 |  | 52 | 31 | 31 | 31
 | 37 | Cesar Augusto | 46567 | 62 |  | 62 | 22 | 22 | 22
 | 38 | [NAME] | 8 | 51 |  | 51 | 47 |  | 47
 | 39 | [NAME] | 423423 | 36 | 36 | 36 | 43 |  | 43
 | 40 | [NAME] | 9877 | 58 |  | 58 | 43 |  | 43
 | 41 | [NAME] | 45345 | 59 |  | 59 | 39 | 40 | 40
 | 42 | [NAME] | 76 | 71 | 71 | 71 | 52 |  | 52
 | 43 | [NAME] R | 67 | 86 | 78 | 82 | 60 |  | 60
 | 44 | Dashan | 6756756 | NS | NS | NS | 40 |  | 40
 | 45 | Dhaval | 56 | 60 |  | 60 | 40 |  | 40
 | 46 | Dhruvik | 365 | 58 |  | 58 | 37 | 40
 | 47 | Dipak | 34345 | 64 |  | 64 | 41 |  | 41
 | 48 | Dmitriy | 6 | 57 |  | 57 | 46 |  | 46
 | 49 | Dmitry | 7689 | NS | NS | NS | NS | NS | NS
 | 50 | Dolly | 86 | 38 | 35 | 35 | 54 |  | 54
 | 51 | [NAME] | 7 | 69 |  | 69 | 35 | 35 | 35
 | 52 | [NAME] | 45367 | 57 |  | 57 | 23 | 23 | 23
 | 53 | [NAME] | 423 | 58 |  | 58 | 16 | 16 | 16
 | 54 | [NAME] | 2 | 52 |  | 52 | 61 |  | 61
 | 55 | [NAME] | 52345 | NS |  | NS | 51 |  | 51
 | 56 | Estella | 235 | 52 |  | 52 | 51 |  | 51
 | 57 | [NAME] | 87654 | 55 |  | 55 | 35 | 35 | 35
 | 58 | [NAME] | 8 | 57 |  | 57 | 28 | 28 | 28
 | 59 | [NAME] | 6 | 41 |  | 41 | 37 | 40 | 40
 | 60 | Farrukh | 4677 | 25 | 25 | 25 | 27 | 27 | 27
 | 61 | Farrukh | 34 | 66 |  | 66 | 43 |  | 43
 | 62 | [NAME] | 6 | 63 |  | 63 | 32 | 32 | 32
 | 63 | Florence | 43 | 53 |  | 53 | 44 |  | 44
 | 64 | [NAME] | 56 | 61 |  | 61 | 34 | 34 | 34
 | 65 | [NAME] | 97887 | 77 | 71 | 74 | 49 | 49 | 49
 | 66 | Gabriele | 678 | 54 |  | 54 | 26 | 26 | 26
 | 67 | Galimzhan | 345345 | 48 |  | 48 | 21 | 21 | 21
 | 68 | [NAME] | 789 | 56 |  | 56 | 28 | 28 | 28
 | 69 | [NAME] | 87978 | 54 |  | 54 | 56 |  | 56
 | 70 | Hammad | 356 | 16 | 16 | 16 | 51 |  | 51
 | 71 | Haoyang | 64564 | 73 |  | 73 | 48 |  | 48
 | 72 | Harriet | 68768 | 60 |  | 60 | 42 | 42 | 42
 | 73 | [NAME] | 36 | NS | NS | NS | 20 | 20 | 20
 | 74 | Hongmei | 2342 | 51 |  | 51 | 50 |  | 50
 | 75 | Hui | 3456 | 31 | 31 | 31 | 42 |  | 42
 | 76 | Huihui | 45645 | NS | NS | NS | 40 |  | 40
 | 77 | Ifeoluwa | 3456 | 67 |  | 67 | 50 |  | 50
 | 78 | [NAME] | 45645 | 55 |  | 55 | 46 |  | 46
 | 79 | [NAME] | 56745 | 62 |  | 62 | 53 |  | 53
 | 80 | [NAME] | 6748 | 30 | 30 | 30 | 33 | 33 | 33
 | 81 | Jian | 8765 | 71 | 71 | 71 | 43 |  | 43
 | 82 | Jianqiao | 9787 | NS |  | NS | 43 |  | 43
 | 83 | [NAME] Sunday | 3256 | 69 |  | 69 | 48 |  | 48
 | 84 | [NAME] | 7568 | 52 |  | 52 | 29 | 29 | 29
 | 85 | [NAME] | 34534 | 56 |  | 56 | 32 |  | 32
 | 86 | [NAME] | 657657 | 66 |  | 66 | 56 |  | 56
 | 87 | [NAME] | 6786678 | NS |  | NS | 54 |  | 54
 | 88 | Kamran | 3453 | 65 |  | 65 | 41 |  | 41
 | 89 | Kaori | 87676 | 72 | 72 | 72 | 42 |  | 42
 | 90 | Kehinde | 3456 | 73 | 71 | 72 | 34 | 34 | 34
 | 91 | Kelly | 98765 | 70 | 70 | 70 | 21 | 21 | 21
 | 92 | [NAME] Kumar | 436 | 58 |  | 58 | 48 |  | 48
 | 93 | [NAME] | 6858 | NS | NS | NS | NS | NS | NS
 | 94 | Krishen | 34547 | 43 |  | 43 | 40 |  | 40
 | 95 | Krunoslav | 754 | 52 | 52 | 52 | 27 | 27 | 27
 | 96 | [NAME] | 7846 | 60 |  | 60 | 42 |  | 42
 | 97 | Liyanage Don Samantha | 743 | 68 |  | 68 | 41 |  | 41
 | 98 | [NAME] | 548678 | 59 |  | 59 | 45 |  | 45
 | 99 | [NAME] | 8456 | 59 |  | 59 | 23 | 23 | 23
 | 100 | Maryam | 45262 | 64 |  | 64 | 42 |  | 42
 | 101 | [NAME] | 76858 | 35 | 35 | 35 | 38 | 40 | 39
 | 102 | [NAME] | 2342 | 58 |  | 58 | 45 |  | 45
 | 103 | Md. [NAME] | 768567 | 57 |  | 57 | 46 |  | 46
 | 104 | Md. Sabbir | 234523 | 60 |  | 60 | 64 |  | 64
 | 105 | Meena | 89578 | 61 |  | 61 | 34 | 34 | 34
 | 106 | Mfon | 432523 | NS | NS | NS | NS | NS | NS
 | 107 | Mihir Shaileshkumar | 879568 | 54 |  | 54 | 26 | 26 | 26 |  |  |  | Final Mark contested
 | 108 | Mir Mosharaf | 243526 | 46 |  | 46 | 33 | 33 | 33
 | 109 | [NAME] | 47846 | NS |  | NS | 46 |  | 46
 | 110 | [NAME] | 2456456 | NS |  | NS | 42 |  | 42
 | 111 | [NAME] | 7867 | NS | NS | NS | NS | NS | NS
 | 112 | [NAME] | 23435 | 58 |  | 58 | 40 |  | 40
 | 113 | [NAME] | 234523 | 61 | 61 | 61 | 32 | 32 | 32
 | 114 | Muftau | 567 | 57 |  | 57 | 53 |  | 53
 | 115 | [NAME] | 57356 | 20 | 20 | 20 | 46 |  | 46
 | 116 | [NAME] | 36573 | 49 | 49 | 49 | 33 | 33 | 33
 | 117 | [NAME] | 633657 | NS |  | NS | 51 |  | 51
 | 118 | [NAME] | 3425 | 58 |  | 58 | 29 | 29 | 29
 | 119 | [NAME] | 56634 | 60 |  | 60 | 28 | 28 | 28
 | 120 | [NAME] | 3753 | 58 |  | 58 | 52 |  | 52
 | 121 | Murat | 3567 | 63 |  | 63 | 9 | 9 | 9
 | 122 | Murtaza | 3657 | 65 |  | 65 | 32 | 32 | 32
 | 123 | [NAME] | 5367 | 17 | 17 | 17 | 38 | 40 | 40
 | 124 | Mustapha | 8795 | 65 |  | 65 | 24 | 24 | 24
 | 125 | [NAME] | 895 | 55 |  | 55 | 30 | 30 | 30
 | 126 | Nadia | 2345 | 60 |  | 60 | 50 | 50 | 50
 | 127 | Najeeb | 1345 | 10 | 10 | 10 | 50 |  | 50
 | 128 | Natalia | 2345 | 53 |  | 53 | 39 | 40 | 40
 | 129 | Natasa | 784 | 82 | 82 | 82 | 31 | 31 | 31
 | 130 | [NAME] | 76854 | 65 |  | 65 | 37 | 40
 | 131 | Nisar | 456 | 60 |  | 60 | 50 | 50 | 50
 | 132 | Nisha | 3657 | NS | NS | NS | NS | NS | NS
 | 133 | Niyaz | 8709 | 57 |  | 57 | 12 | 12 | 12
 | 134 | Nkechi | 897 | 72 | 71 | 71 | 48 |  | 48
 | 135 | Nobert | 5436 | 47 |  | 47 | 51 |  | 51
 | 136 | Noopur | 568 | 53 | 55 | 54 | 45 |  | 45