Spreadsheet: 881594d1729699428-need-formula-for-multiple-lookups-to-return-just-one-value-excel-forum-question-multiple-lookup-to-return-one-value
Sheet: Data

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