Spreadsheet: 881596d1729703628-need-formula-for-multiple-lookups-to-return-just-one-value-excel-forum-question-multiple-lookup-to-return-one-value
Sheet: Datax

 |  |  | columns needed for progress
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) | Subject
ALD002​ | ALDERTON, [NAME] | 5= | 5= | [NAME] | Biology
ALD002​ | ALDERTON, [NAME] | 7= | 7= | [NAME] | Chemistry
ALD002​ | ALDERTON, [NAME] | 4= | 4= | [NAME] | Design Technology
ALD002​ | ALDERTON, [NAME] | 6= | 6= | VG | Drama
ALD002​ | ALDERTON, [NAME] | 5+ | 5+ | VG | English Language
ALD002​ | ALDERTON, [NAME] | 4= | 4= | [NAME] | English Literature
ALD002​ | ALDERTON, [NAME] | 4+ | 4+ | VG | Geography
ALD002​ | ALDERTON, [NAME] | 5+ | 5+ | VG | Mathematics
ALD002​ | ALDERTON, [NAME] | M |  | VG | Music Technology
ALD002​ | ALDERTON, [NAME] | 6- | 6- | [NAME] | Physics
ALD002​ | ALDERTON, [NAME] | [NAME] |  | [NAME] | RSE
BEA003​ | BEAN, [NAME] | 8+ | 8+ | EX | Biology
BEA003​ | BEAN, [NAME] | 7+ | 7+ | EX | Chemistry
BEA003​ | BEAN, [NAME] | 7- | 7- | VG | English Language
BEA003​ | BEAN, [NAME] | 7- | 7- | VG | English Literature
BEA003​ | BEAN, [NAME] | 6- | 6- | VG | French
BEA003​ | BEAN, [NAME] | 8- | 8- | EX | Geography
BEA003​ | BEAN, [NAME] | 7= | 7= | VG | Mathematics
BEA003​ | BEAN, [NAME] | 7+ | 7+ | VG | Physical Education
BEA003​ | BEAN, [NAME] | 7+ | 7+ | VG | Physical Education
BEA003​ | BEAN, [NAME] | 9- | 9- | [NAME] | Physics
BEA003​ | BEAN, [NAME] | VG |  | VG | RSE
CAM009​ | CAMPBELL, Sapphire | 4= | 4= | [NAME] | Biology
CAM009​ | CAMPBELL, Sapphire | 6+ | 6+ | [NAME] | Chemistry
CAM009​ | CAMPBELL, Sapphire | 6+ | 6+ | VG | Drama
CAM009​ | CAMPBELL, Sapphire | 6- | 6- | VG | English Language
CAM009​ | CAMPBELL, Sapphire | 6= | 6= | VG | English Literature
CAM009​ | CAMPBELL, Sapphire | 5+ | 5+ | VG | Mathematics
CAM009​ | CAMPBELL, Sapphire | 6= | 6= | VG | Music
CAM009​ | CAMPBELL, Sapphire | 7+ | 7+ | [NAME] | Physics
CAM009​ | CAMPBELL, Sapphire | 6- | 6- | VG | Religious Studies
CAM009​ | CAMPBELL, Sapphire | [NAME] |  | [NAME] | RSE
CAN006​ | CANTLIFF, Summer | 4= | 4= | IC | Biology
CAN006​ | CANTLIFF, Summer | 6= | 6= | [NAME] | Chemistry
CAN006​ | CANTLIFF, Summer | 5+ | 5+ | VG | Design Technology
CAN006​ | CANTLIFF, Summer | 6+ | 6+ | VG | Drama
CAN006​ | CANTLIFF, Summer | 6= | 6= | VG | English Language
CAN006​ | CANTLIFF, Summer | 6= | 6= | VG | English Literature
CAN006​ | CANTLIFF, Summer | 7= | 7= | VG | Geography
CAN006​ | CANTLIFF, Summer | 6- | 6- | [NAME] | Mathematics
CAN006​ | CANTLIFF, Summer | 6- | 6- | [NAME] | Physics
CAN006​ | CANTLIFF, Summer | [NAME] |  | [NAME] | RSE
CAT006​ | CATTIGAN, [NAME] | 6= | 6= | [NAME] | Art
CAT006​ | CATTIGAN, [NAME] | 5= | 5= | [NAME] | Biology
CAT006​ | CATTIGAN, [NAME] | 5- | 5- | [NAME] | Chemistry
CAT006​ | CATTIGAN, [NAME] | 6+ | 6+ | VG | Drama
CAT006​ | CATTIGAN, [NAME] | 6- | 6- | [NAME] | English Language
CAT006​ | CATTIGAN, [NAME] | 7- | 7- | [NAME] | English Literature
CAT006​ | CATTIGAN, [NAME] | 6- | 6- | EX | Mathematics
CAT006​ | CATTIGAN, [NAME] | 6- | 6- | [NAME] | Physics
CAT006​ | CATTIGAN, [NAME] | [NAME] |  | [NAME] | RSE
FEN008​ | FENNELL, [NAME] | 5- | 5- | [NAME] | Art
FEN008​ | FENNELL, [NAME] | 4- | 4- | [NAME] | Biology
FEN008​ | FENNELL, [NAME] | 3- | 3- | [NAME] | Chemistry
FEN008​ | FENNELL, [NAME] | 4= | 4= | [NAME] | Design Technology
FEN008​ | FENNELL, [NAME] | [NAME] |  | [NAME] | English Language
FEN008​ | FENNELL, [NAME] | 5- | 5- | [NAME] | English Literature
FEN008​ | FENNELL, [NAME] | 4+ | 4+ | [NAME] | Mathematics
FEN008​ | FENNELL, [NAME] | 4- | 4- | [NAME] | Physics
FEN008​ | FENNELL, [NAME] | P |  | [NAME] | Travel and Tourism
GRO006​ | GROUT, [NAME] | 6+ | 6+ | VG | Art
GRO006​ | GROUT, [NAME] | 4- | 4- | [NAME] | Biology
GRO006​ | GROUT, [NAME] | 3- | 3- | [NAME] | Chemistry
GRO006​ | GROUT, [NAME] | 7- | 7- | EX | Drama
GRO006​ | GROUT, [NAME] | 6+ | 6+ | EX | English Language
GRO006​ | GROUT, [NAME] | 6+ | 6+ | EX | English Literature
GRO006​ | GROUT, [NAME] | 5- | 5- | VG | Mathematics
GRO006​ | GROUT, [NAME] | 8- | 8- | VG | Music
GRO006​ | GROUT, [NAME] | 4+ | 4+ | VG | Physics
GRO006​ | GROUT, [NAME] | 5= | 5= | EX | Religious Studies
GRO006​ | GROUT, [NAME] | VG |  | VG | RSE