Spreadsheet: 881637d1729766141-need-formula-for-multiple-lookups-to-return-just-one-value-excel-forum-question-multiple-lookup-to-return-one-value-atl-not-working
Sheet: DATA TO USE

 |  |  |  |  | columns needed for progress
Year Group (lookup) | Year Group numerical | Student Code | Student Formal Name | IMPORTED Mark/Grade Value | GRADES - copied from E , sorted Z-A then manually removed ATL & any Y13 predicted grades | ATL                                                  (formula cell) | [NAME] copied from E then sorted column I by colour and manually removed any NOT predicted info | Assessment Title | Subject
 | 11 | ALD002​ | ALDERSEY, [NAME] | 5= | 5= |  |  | M1 - Biology | Biology
 | 11 | ALD002​ | ALDERSEY, [NAME] | [NAME] |  |  |  | M1 - Biology | Biology
 | 11 | ALD002​ | ALDERSEY, [NAME] | 7= | 7= |  |  | M1 - Chemistry | Chemistry
 | 11 | ALD002​ | ALDERSEY, [NAME] | [NAME] |  |  |  | M1 - Chemistry | Chemistry
 | 11 | ALD002​ | ALDERSEY, [NAME] | 4= | 4= |  |  | M1 - Design Technology | Design Technology
 | 11 | ALD002​ | ALDERSEY, [NAME] | [NAME] |  |  |  | M1 - Design Technology | Design Technology
 | 11 | ALD002​ | ALDERSEY, [NAME] | 6= | 6= |  |  | M1 - Drama | Drama
 | 11 | ALD002​ | ALDERSEY, [NAME] | VG |  |  |  | M1 - Drama | Drama
 | 11 | ALD002​ | ALDERSEY, [NAME] | 5+ | 5+ |  |  | M1 - English Language | English Language
 | 11 | ALD002​ | ALDERSEY, [NAME] | VG |  |  |  | M1 - English Language | English Language
 | 11 | ALD002​ | ALDERSEY, [NAME] | 4= | 4= |  |  | M1 - English Literature | English Literature
 | 11 | ALD002​ | ALDERSEY, [NAME] | [NAME] |  |  |  | M1 - English Literature | English Literature
 | 11 | ALD002​ | ALDERSEY, [NAME] | 4+ | 4+ |  |  | M1 - Geography | Geography
 | 11 | ALD002​ | ALDERSEY, [NAME] | VG |  |  |  | M1 - Geography | Geography
 | 11 | ALD002​ | ALDERSEY, [NAME] | 5+ | 5+ |  |  | M1 - Mathematics | Mathematics
 | 11 | ALD002​ | ALDERSEY, [NAME] | VG |  |  |  | M1 - Mathematics | Mathematics
 | 11 | ALD002​ | ALDERSEY, [NAME] | M |  |  |  | M1 - Music Tech | Music Technology
 | 11 | ALD002​ | ALDERSEY, [NAME] | VG |  |  |  | M1 - Music Tech | Music Technology
 | 11 | ALD002​ | ALDERSEY, [NAME] | 6- | 6- |  |  | M1 - Physics | Physics
 | 11 | ALD002​ | ALDERSEY, [NAME] | [NAME] |  |  |  | M1 - Physics | Physics
 | 11 | ALD002​ | ALDERSEY, [NAME] | [NAME] |  |  |  | M1 - RSE | RSE
 | 11 | BEA003​ | BEANEY, Portia | 8+ | 8+ |  |  | M1 - Biology | Biology
 | 11 | BEA003​ | BEANEY, Portia | EX |  |  |  | M1 - Biology | Biology
 | 11 | BEA003​ | BEANEY, Portia | 7+ | 7+ |  |  | M1 - Chemistry | Chemistry
 | 11 | BEA003​ | BEANEY, Portia | EX |  |  |  | M1 - Chemistry | Chemistry
 | 11 | BEA003​ | BEANEY, Portia | 7- | 7- |  |  | M1 - English Language | English Language
 | 11 | BEA003​ | BEANEY, Portia | VG |  |  |  | M1 - English Language | English Language
 | 11 | BEA003​ | BEANEY, Portia | 7- | 7- |  |  | M1 - English Literature | English Literature
 | 11 | BEA003​ | BEANEY, Portia | VG |  |  |  | M1 - English Literature | English Literature
 | 11 | BEA003​ | BEANEY, Portia | 6- | 6- |  |  | M1 - French | French
 | 11 | BEA003​ | BEANEY, Portia | VG |  |  |  | M1 - French | French
 | 11 | BEA003​ | BEANEY, Portia | 8- | 8- |  |  | M1 - Geography | Geography
 | 11 | BEA003​ | BEANEY, Portia | EX |  |  |  | M1 - Geography | Geography
 | 11 | BEA003​ | BEANEY, Portia | 7= | 7= |  |  | M1 - Mathematics | Mathematics
 | 11 | BEA003​ | BEANEY, Portia | VG |  |  |  | M1 - Mathematics | Mathematics
 | 11 | BEA003​ | BEANEY, Portia | 7+ | 7+ |  |  | M1 - Physical Education | Physical Education
 | 11 | BEA003​ | BEANEY, Portia | 7+ | 7+ |  |  | M1 - Physical Education | Physical Education
 | 11 | BEA003​ | BEANEY, Portia | VG |  |  |  | M1 - Physical Education | Physical Education
 | 11 | BEA003​ | BEANEY, Portia | VG |  |  |  | M1 - Physical Education | Physical Education
 | 11 | BEA003​ | BEANEY, Portia | 9- | 9- |  |  | M1 - Physics | Physics
 | 11 | BEA003​ | BEANEY, Portia | [NAME] |  |  |  | M1 - Physics | Physics
 | 11 | BEA003​ | BEANEY, Portia | VG |  |  |  | M1 - RSE | RSE
 | 11 | BIR011​ | BIRKETT, [NAME] | 2- | 2- |  |  | M1 - Biology | Biology
 | 11 | BIR011​ | BIRKETT, [NAME] | [NAME] |  |  |  | M1 - Biology | Biology
 | 11 | BIR011​ | BIRKETT, [NAME] | 1- | 1- |  |  | M1 - Chemistry | Chemistry
 | 11 | BIR011​ | BIRKETT, [NAME] | [NAME] |  |  |  | M1 - Chemistry | Chemistry
 | 11 | BIR011​ | BIRKETT, [NAME] | 5+ | 5+ |  |  | M1 - Drama | Drama
 | 11 | BIR011​ | BIRKETT, [NAME] | VG |  |  |  | M1 - Drama | Drama
 | 11 | BIR011​ | BIRKETT, [NAME] | 6= | 6= |  |  | M1 - English Language | English Language
 | 11 | BIR011​ | BIRKETT, [NAME] | EX |  |  |  | M1 - English Language | English Language
 | 11 | BIR011​ | BIRKETT, [NAME] | 6= | 6= |  |  | M1 - English Literature | English Literature
 | 11 | BIR011​ | BIRKETT, [NAME] | EX |  |  |  | M1 - English Literature | English Literature
 | 11 | BIR011​ | BIRKETT, [NAME] | 3- | 3- |  |  | M1 - Mathematics | Mathematics
 | 11 | BIR011​ | BIRKETT, [NAME] | VG |  |  |  | M1 - Mathematics | Mathematics
 | 11 | BIR011​ | BIRKETT, [NAME] | 6- | 6- |  |  | M1 - Music | Music
 | 11 | BIR011​ | BIRKETT, [NAME] | VG |  |  |  | M1 - Music | Music
 | 11 | BIR011​ | BIRKETT, [NAME] | Di | Di |  |  | M1 - Music Tech | Music Technology
 | 11 | BIR011​ | BIRKETT, [NAME] | VG |  |  |  | M1 - Music Tech | Music Technology
 | 11 | BIR011​ | BIRKETT, [NAME] | 3- | 3- |  |  | M1 - Physics | Physics
 | 11 | BIR011​ | BIRKETT, [NAME] | [NAME] |  |  |  | M1 - Physics | Physics
 | 11 | BIR011​ | BIRKETT, [NAME] | [NAME] |  |  |  | M1 - RSE | RSE
 | 11 | [NAME] | BRADSHAW, [NAME] | 3= | 3= |  |  | M1 - Biology | Biology
 | 11 | [NAME] | BRADSHAW, [NAME] | [NAME] |  |  |  | M1 - Biology | Biology
 | 11 | [NAME] | BRADSHAW, [NAME] | 4= | 4= |  |  | M1 - Business Studies | Business Studies
 | 11 | [NAME] | BRADSHAW, [NAME] | [NAME] |  |  |  | M1 - Business Studies | Business Studies
 | 11 | [NAME] | BRADSHAW, [NAME] | 6- | 6- |  |  | M1 - Chemistry | Chemistry
 | 11 | [NAME] | BRADSHAW, [NAME] | [NAME] |  |  |  | M1 - Chemistry | Chemistry
 | 11 | [NAME] | BRADSHAW, [NAME] | 4+ | 4+ |  |  | M1 - English Language | English Language
 | 11 | [NAME] | BRADSHAW, [NAME] | [NAME] |  |  |  | M1 - English Language | English Language
 | 11 | [NAME] | BRADSHAW, [NAME] | 4+ | 4+ |  |  | M1 - English Literature | English Literature
 | 11 | [NAME] | BRADSHAW, [NAME] | [NAME] |  |  |  | M1 - English Literature | English Literature
 | 11 | [NAME] | BRADSHAW, [NAME] | 5+ | 5+ |  |  | M1 - History | History
 | 11 | [NAME] | BRADSHAW, [NAME] | [NAME] |  |  |  | M1 - History | History
 | 11 | [NAME] | BRADSHAW, [NAME] | 5= | 5= |  |  | M1 - Mathematics | Mathematics
 | 11 | [NAME] | BRADSHAW, [NAME] | VG |  |  |  | M1 - Mathematics | Mathematics
 | 11 | [NAME] | BRADSHAW, [NAME] | 5= | 5= |  |  | M1 - Physics | Physics
 | 11 | [NAME] | BRADSHAW, [NAME] | [NAME] |  |  |  | M1 - Physics | Physics
 | 11 | [NAME] | BRADSHAW, [NAME] | [NAME] |  |  |  | M1 - RSE | RSE
 | 11 | [NAME] | BRADSHAW, [NAME] | 4- | 4- |  |  | M1 - Spanish | Spanish
 | 11 | [NAME] | BRADSHAW, [NAME] | VG |  |  |  | M1 - Spanish | Spanish
 | 11 | [NAME] | BRADSHAW, [NAME] |  |  |  |  | M1 - Sport and Fitness | Sport and Fitness
 | 11 | [NAME] | BRADSHAW, [NAME] |  |  |  |  | M1 - Sport and Fitness | Sport and Fitness
 | 11 | CAM009​ | CAMPBELL, Rowena | 4= | 4= |  |  | M1 - Biology | Biology
 | 11 | CAM009​ | CAMPBELL, Rowena | [NAME] |  |  |  | M1 - Biology | Biology
 | 11 | CAM009​ | CAMPBELL, Rowena | 6+ | 6+ |  |  | M1 - Chemistry | Chemistry
 | 11 | CAM009​ | CAMPBELL, Rowena | [NAME] |  |  |  | M1 - Chemistry | Chemistry
 | 11 | CAM009​ | CAMPBELL, Rowena | 6+ | 6+ |  |  | M1 - Drama | Drama
 | 11 | CAM009​ | CAMPBELL, Rowena | VG |  |  |  | M1 - Drama | Drama
 | 11 | CAM009​ | CAMPBELL, Rowena | 6- | 6- |  |  | M1 - English Language | English Language
 | 11 | CAM009​ | CAMPBELL, Rowena | VG |  |  |  | M1 - English Language | English Language
 | 11 | CAM009​ | CAMPBELL, Rowena | 6= | 6= |  |  | M1 - English Literature | English Literature
 | 11 | CAM009​ | CAMPBELL, Rowena | VG |  |  |  | M1 - English Literature | English Literature
 | 11 | CAM009​ | CAMPBELL, Rowena | 5+ | 5+ |  |  | M1 - Mathematics | Mathematics
 | 11 | CAM009​ | CAMPBELL, Rowena | VG |  |  |  | M1 - Mathematics | Mathematics
 | 11 | CAM009​ | CAMPBELL, Rowena | 6= | 6= |  |  | M1 - Music | Music
 | 11 | CAM009​ | CAMPBELL, Rowena | VG |  |  |  | M1 - Music | Music
 | 11 | CAM009​ | CAMPBELL, Rowena | 7+ | 7+ |  |  | M1 - Physics | Physics
 | 11 | CAM009​ | CAMPBELL, Rowena | [NAME] |  |  |  | M1 - Physics | Physics
 | 11 | CAM009​ | CAMPBELL, Rowena | 6- | 6- |  |  | M1 - Religious Studies | Religious Studies
 | 11 | CAM009​ | CAMPBELL, Rowena | VG |  |  |  | M1 - Religious Studies | Religious Studies
 | 11 | CAM009​ | CAMPBELL, Rowena | [NAME] |  |  |  | M1 - RSE | RSE
 | 11 | CAN006​ | CANTLIFF, Niall | 4= | 4= |  |  | M1 - Biology | Biology
 | 11 | CAN006​ | CANTLIFF, Niall | IC |  |  |  | M1 - Biology | Biology
 | 11 | CAN006​ | CANTLIFF, Niall | 6= | 6= |  |  | M1 - Chemistry | Chemistry
 | 11 | CAN006​ | CANTLIFF, Niall | [NAME] |  |  |  | M1 - Chemistry | Chemistry
 | 11 | CAN006​ | CANTLIFF, Niall | 5+ | 5+ |  |  | M1 - Design Technology | Design Technology
 | 11 | CAN006​ | CANTLIFF, Niall | VG |  |  |  | M1 - Design Technology | Design Technology
 | 11 | CAN006​ | CANTLIFF, Niall | 6+ | 6+ |  |  | M1 - Drama | Drama
 | 11 | CAN006​ | CANTLIFF, Niall | VG |  |  |  | M1 - Drama | Drama
 | 11 | CAN006​ | CANTLIFF, Niall | 6= | 6= |  |  | M1 - English Language | English Language
 | 11 | CAN006​ | CANTLIFF, Niall | VG |  |  |  | M1 - English Language | English Language
 | 11 | CAN006​ | CANTLIFF, Niall | 6= | 6= |  |  | M1 - English Literature | English Literature
 | 11 | CAN006​ | CANTLIFF, Niall | VG |  |  |  | M1 - English Literature | English Literature
 | 11 | CAN006​ | CANTLIFF, Niall | 7= | 7= |  |  | M1 - Geography | Geography
 | 11 | CAN006​ | CANTLIFF, Niall | VG |  |  |  | M1 - Geography | Geography
 | 11 | CAN006​ | CANTLIFF, Niall | 6- | 6- |  |  | M1 - Mathematics | Mathematics
 | 11 | CAN006​ | CANTLIFF, Niall | [NAME] |  |  |  | M1 - Mathematics | Mathematics
 | 11 | CAN006​ | CANTLIFF, Niall | 6- | 6- |  |  | M1 - Physics | Physics
 | 11 | CAN006​ | CANTLIFF, Niall | [NAME] |  |  |  | M1 - Physics | Physics
 | 11 | CAN006​ | CANTLIFF, Niall | [NAME] |  |  |  | M1 - RSE | RSE
 | 11 | CAT006​ | CATTIGAN, Orlaith | 6= | 6= |  |  | M1 - Art | Art
 | 11 | CAT006​ | CATTIGAN, Orlaith | [NAME] |  |  |  | M1 - Art | Art
 | 11 | CAT006​ | CATTIGAN, Orlaith | 5= | 5= |  |  | M1 - Biology | Biology
 | 11 | CAT006​ | CATTIGAN, Orlaith | [NAME] |  |  |  | M1 - Biology | Biology
 | 11 | CAT006​ | CATTIGAN, Orlaith |  |  |  |  | M1 - Business Studies | Business Studies
 | 11 | CAT006​ | CATTIGAN, Orlaith |  |  |  |  | M1 - Business Studies | Business Studies
 | 11 | CAT006​ | CATTIGAN, Orlaith | 5- | 5- |  |  | M1 - Chemistry | Chemistry
 | 11 | CAT006​ | CATTIGAN, Orlaith | [NAME] |  |  |  | M1 - Chemistry | Chemistry
 | 11 | CAT006​ | CATTIGAN, Orlaith | 6+ | 6+ |  |  | M1 - Drama | Drama
 | 11 | CAT006​ | CATTIGAN, Orlaith | VG |  |  |  | M1 - Drama | Drama
 | 11 | CAT006​ | CATTIGAN, Orlaith | 6- | 6- |  |  | M1 - English Language | English Language
 | 11 | CAT006​ | CATTIGAN, Orlaith | [NAME] |  |  |  | M1 - English Language | English Language
 | 11 | CAT006​ | CATTIGAN, Orlaith | 7- | 7- |  |  | M1 - English Literature | English Literature
 | 11 | CAT006​ | CATTIGAN, Orlaith | [NAME] |  |  |  | M1 - English Literature | English Literature
 | 11 | CAT006​ | CATTIGAN, Orlaith | 6- | 6- |  |  | M1 - Mathematics | Mathematics
 | 11 | CAT006​ | CATTIGAN, Orlaith | EX |  |  |  | M1 - Mathematics | Mathematics
 | 11 | CAT006​ | CATTIGAN, Orlaith | 6- | 6- |  |  | M1 - Physics | Physics
 | 11 | CAT006​ | CATTIGAN, Orlaith | [NAME] |  |  |  | M1 - Physics | Physics
 | 11 | CAT006​ | CATTIGAN, Orlaith | [NAME] |  |  |  | M1 - RSE | RSE
 | 11 | CAT006​ | CATTIGAN, Orlaith |  |  |  |  | M1 - Sport and Fitness | Sport and Fitness
 | 11 | CAT006​ | CATTIGAN, Orlaith |  |  |  |  | M1 - Sport and Fitness | Sport and Fitness