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

 |  | First Name | ID | Maths
email
 |  |  |  | Cwrk |  |  | Exam |  |  | Total | Grade
 |  |  |  | 1st Mark | 2nd Mark | 0.8 | 1st Mark | 2nd Mark | 0.2 | 1
 | 1 | A S M Shamshear | 1233 | 48 |  | 48 | 63 |  | 63
 | 2 | [NAME] | 2444 | 70 | 70 | 70 | 50 |  | 50
 | 3 | [NAME] | 345345 | 68 |  | 68 | 63 |  | 63
 | 4 | Aimal | 67765 | 50 |  | 50 | 72 | 74 | 73
 | 5 | Ajay | 54787 | 76 | 76 | 76 | 61 |  | 61
 | 6 | [NAME] | 4353 | 60 |  | 60 | 61 |  | 61
 | 7 | [NAME] | 8797 | 45 |  | 45 | 62 |  | 62
 | 8 | Alberto | 345368 | 50 |  | 50 | 65 |  | 65
 | 9 | Alina | 56754 | 52 |  | 52 | 63 |  | 63
 | 10 | Amrit | 45658 | 57 |  | 57 | 56 |  | 56
 | 11 | Ana | 7489 | 75 | 76 | 75 | 64 |  | 64
 | 12 | Aneesh | 98743 | 48 |  | 48 | 61 |  | 61
 | 13 | [NAME] | 54756 | NS | NS | NS | 48 | 48 | 48
 | 14 | Arti | 765446 | 5 | 5 | 5 | 60 |  | 60
 | 15 | [NAME] | 65488 | 40 | 40 | 40 | 63 |  | 63
 | 16 | Atish | 64745 | 74 | 74 | 74 | 53 |  | 53
 | 17 | [NAME] | 3567536 | 68 | 68 | 68 | 58 |  | 58
 | 18 | [NAME] | 45624 | 40 | 38 | 40 | 24 | 22 | 23
 | 19 | [NAME] | 6573567 | NS | NS | NS | 40 | 32 | 36
 | 20 | [NAME] | 23424 | 47 |  | 47 | 27 | 29 | 28
 | 21 | Cesar Augusto | 2345235 | NS | NS | NS | 35 | 30 | 33
 | 22 | [NAME] | 90887 | NS | NS | NS | 54 |  | 54
 | 23 | [NAME] | 3456 | 75 | 75 | 75 | 70 | 74 | 72
 | 24 | [NAME] | 987789 | 50 |  | 50 | 56 |  | 56
 | 25 | [NAME] | 4563 | 32 | 32 | 32 | 59 |  | 59
 | 26 | [NAME] R | 3456 | 60 |  | 60 | 38 | 40 | 40
 | 27 | Dhruvik | 4567 | 58 |  | 58 | 70 | 70 | 70
 | 28 | Dipak | 345698 | NS | NS | NS | NS | NS | NS
 | 29 | Dmitry | 87 | 33 | 32 | 33 | 45 | 45 | 45
 | 30 | Dolly | 7896 | NS | NS | NS | NS | NS | NS
 | 31 | [NAME] | 435353 | 6 | 5 | 6 | 22 | 26 | 24
 | 32 | [NAME] | 54643 | 72 | 72 | 72 | 50 |  | 50
 | 33 | [NAME] | 78 | 50 |  | 50 | 50 |  | 50
 | 34 | Estella | 90 | 44 |  | 44 | 66 |  | 66
 | 35 | [NAME] | 8908 | 44 |  | 44 | 50 |  | 50
 | 36 | [NAME] | 90 | 54 |  | 54 | 20 | 21 | 21
 | 37 | Farrukh | 46567 | 34 | 34 | 34 | 48 | 48 | 48
 | 38 | Florence | 8 | 68 |  | 68 | 33 | 40
 | 39 | Gabriele | 67567 | 47 |  | 47 | 53 |  | 53
 | 40 | Galimzhan | 9877 | 47 |  | 47 | 59 |  | 59
 | 41 | [NAME] | 45345 | NS | NS | NS | NS | NS | NS
 | 42 | Hammad | 76 | 47 |  | 47 | 67 |  | 67
 | 43 | Haoyang | 67 | 36 | 36 | 36 | 54 |  | 54
 | 44 | [NAME] | 876543 | 63 |  | 63 | 48 | 45 | 47
 | 45 | Hui | 56 | NS | NS | NS | 53 | 54 | 54
 | 46 | Huihui | 365 | 44 |  | 44 | 52 |  | 52
 | 47 | [NAME] | 34345 | NS | NS | NS | 48 | 48 | 48
 | 48 | Jian | 6 | 56 |  | 56 | 61 |  | 61
 | 49 | Jianqiao | 7689 | 33 | 33 | 33 | 51 |  | 51
 | 50 | [NAME] | 86 | 52 |  | 52 | 64 |  | 64
 | 51 | [NAME] | 7 | 60 |  | 60 | 66 |  | 66
 | 52 | Kaori | 45367 | 53 |  | 53 | 57 |  | 57
 | 53 | Kelly | 423 | 53 |  | 53 | 51 |  | 51
 | 54 | Krishen | 2 | 48 |  | 48 | 57 |  | 57
 | 55 | Krunoslav | 52345 | 55 |  | 55 | 50 |  | 50
 | 56 | [NAME] | 235 | 70 | 70 | 70 | 61 |  | 61
 | 57 | [NAME] | 87654 | 36 | 35 | 36 | 30 | 32 | 31
 | 58 | Mfon | 8 | 42 |  | 42 | 50 |  | 50
 | 59 | Mihir Shaileshkumar | 6 | 35 | 35 | 35 | 52 |  | 52
 | 60 | Mir Mosharaf | 4677 | 47 |  | 47 | 41 | 49 | 45
 | 61 | [NAME] | 34 | 48 |  | 48 | 55 |  | 55
 | 62 | [NAME] | 6 | 57 | 57 | 57 | 58 |  | 58
 | 63 | [NAME] | 43 | 58 |  | 58 | 50 |  | 50
 | 64 | [NAME] | 56 | NS | NS | NS | NS | NS | NS
 | 65 | [NAME] | 97887 | NS | NS | NS | 27 | 15 | 21
 | 66 | Muftau | 678 | 82 | 82 | 82 | 54 |  | 54
 | 67 | [NAME] | 345345 | 45 |  | 45 | 39 | 42 | 41
 | 68 | [NAME] | 789 | 37 | 36 | 37 | 44 | 50 | 47
 | 69 | [NAME] | 87978 | 35 | 35 | 35 | 51 |  | 51
 | 70 | [NAME] | 356 | 55 |  | 55 | 51 |  | 51
 | 71 | Murtaza | 64564 | 62 |  | 62 | 53 |  | 53
 | 72 | [NAME] | 68768 | 63 |  | 63 | 54 |  | 54
 | 73 | [NAME] | 36 | NS | NS | NS | 50 |  | 50
 | 74 | Najeeb | 2342 | 43 |  | 43 | 54 |  | 54
 | 75 | Natasa | 3456 | 45 | 45 | 45 | 63 |  | 63
 | 76 | [NAME] | 45645 | 34 | 33 | 34 | 43 | 40 | 42
 | 77 | Nisar | 3456 | 50 |  | 50 | 73 | 71 | 72
 | 78 | Niyaz | 45645 | NS | NS | NS | 67 |  | 67
 | 79 | Nobert | 56745 | 52 |  | 52 | 66 | 66 | 66
 | 80 | Noopur | 6748 | 35 | 35 | 35 | 44 | 46 | 45