Spreadsheet: 170626d1343334457-how-do-i-return-a-header-of-column-based-on-a-range-of-cells-containing-specific-data-test-spreadsheet
Sheet: Sheet1

School Year: |  |  |  | 12-13'
Name | ID | Dept | P1-Year 1-Prob | P2-Year 2-Prob | P3-Year 3-Prob | P4-Year 4-Prob | R1-Year 1-Reg | R2-Year2-Reg | R3-Year 3-Reg
[NAME], [NAME] | A01434598 | Agriculture |  |  |  |  |  | 11-12' | 12-13'
[NAME], [NAME] | A01427512 | Agriculture |  |  |  |  | 12-13' |  | 11-12'
Lopez, [NAME] | A01432683 | Agriculture |  |  |  |  | 11-12' | 12-13'
Scott, [NAME] | A01430776 | Agriculture |  |  |  |  | 11-12' | 12-13'
Uyeno, Gary | A01428760 | Agriculture |  |  |  |  | 12-13' |  | 11-12'
[NAME] , [NAME] | A01430269 | Agriculture |  |  |  |  | 11-12' | 12-13'
Padilla, Maya | A02528627 | Agriculture | 11-12" | 12-13'
Phillips, [NAME] | [NAME] | Agriculture |  |  |  | 11-12" | 12-13'
Waters, [NAME] | A01425435 | Agriculture |  |  |  | 11-12" | 12-13'
[NAME] , [NAME] | A01424273 | Biology |  |  |  |  |  | 11-12' | 12-13'
[NAME], [NAME] | A01434577 | Biology |  |  |  |  |  | 11-12' | 12-13'
Borella , Frances | A01432106 | Biology |  |  |  |  |  | 11-12' | 12-13'
Briggs, [NAME] |  | Biology | 12-13'
Cooper, Mark | A01429953 | Biology |  |  |  |  | 11-12' | 12-13'
[NAME], Lynda | A01424834 | Biology |  |  |  |  | 11-12' | 12-13'
Kakiba Russel, [NAME] | A01430881 | Biology |  |  |  |  |  | 11-12' | 12-13'
[NAME], [NAME] | A01433349 | Biology |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01432395 | Biology |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01432596 | Biology |  |  |  |  | 11-12' | 12-13'
Meyer, [NAME] | A01432605 | Biology |  |  |  |  | 11-12' | 12-13'
[NAME], [NAME] | A01432393 | Biology |  |  |  |  | 11-12' | 12-13'
Nguyen, KimLeiloni | A01432394 | Biology |  |  |  |  | 11-12' | 12-13'
Pascoe , Virginia | A01428173 | Biology |  |  |  |  |  | 11-12' | 12-13'
Petersen, [NAME] | A01427755 | Biology |  |  |  |  | 12-13' |  | 11-12'
Revell, [NAME] | A01432097 | Biology |  |  |  |  | 12-13' |  | 11-12'
Rexach, Carmen | A01433964 | Biology |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01431061 | Biology |  |  |  |  | 11-12' | 12-13'
Scott, [NAME] | A01426958 | Biology |  |  |  |  | 11-12' | 12-13'
Shannon, [NAME] | A01424677 | Biology |  |  |  |  | 11-12' | 12-13'
Vail, Deidre | A01428418 | Biology |  |  |  |  | 11-12' | 12-13'
[NAME] , Carola | A01432677 | Biology |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01427063 | Biology |  |  |  | 11-12" | 12-13'
Golestaneh, Kamran | A01428060 | Chemistry |  |  |  | 11-12" | 12-13'
Beam, Teresa | A01425562 | Chemistry |  |  |  |  |  | 11-12' | 12-13'
[NAME], [NAME] | A01427105 | Chemistry |  |  |  |  | 11-12' | 12-13'
Clemments, Todd |  | Chemistry | 12-13'
Di Mauro , Eileen | A01426797 | Chemistry |  |  |  |  | 11-12' | 12-13'
Hoover, [NAME] | A01433883 | Chemistry |  |  |  |  |  | 11-12' | 12-13'
[NAME] , [NAME] | A01433328 | Chemistry |  |  |  |  |  | 11-12' | 12-13'
[NAME], [NAME] | A01433049 | Chemistry |  |  |  |  |  | 11-12' | 12-13'
[NAME], Iraq | A01425628 | Chemistry |  |  |  |  |  | 11-12' | 12-13'
Newman , [NAME] | A01432364 | Chemistry |  |  |  |  | 12-13' |  | 11-12'
[NAME] , [NAME] | A01433120 | Chemistry |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01433121 | Chemistry |  |  |  |  | 12-13' |  | 11-12'
Hood, [NAME] | A02638733 | ESA |  |  | 11-12' | 12-13'
Lackey, Hilary | A02685676 | ESA |  | 11-12' | 12-13'
Boryta , Mark | A01432660 | ESA |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01432858 | ESA |  |  |  |  | 11-12' | 12-13'
[NAME], Micol | A01434051 | ESA |  |  |  |  | 12-13' |  | 11-12'
[NAME], Heather | A02764955 | ESA | 12-13'
Walker, Rebecca | A01435288 | ESA |  |  |  |  |  | 11-12' | 12-13'
Webb, [NAME] | A01424875 | ESA |  |  |  |  | 12-13' |  | 11-12'
Mrofka, [NAME] | A02721130 | ESA | 11-12" | 12-13'
[NAME], [NAME] | A02721129 | Math | 11-12" | 12-13'
Campbell, [NAME] | A02725182 | Math | 11-12" | 12-13'
[NAME], Dolores | A01439844 | Math |  |  |  | 11-12" | 12-13'
Lancaster, Stephen | A02721370 | Math | 11-12" | 12-13'
Birca, Alina | A01434038 | Math |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01435245 | Math |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01424440 | Math |  |  |  |  | 11-12' | 12-13'
[NAME] | A02685719 | Math |  | 11-12' | 12-13'
[NAME], [NAME] | A01428856 | Math |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01431190 | Math |  |  |  |  |  | 11-12' | 12-13'
Griffith, Hugh | A01431190 | Math |  |  |  |  | 11-12' | 12-13'
Guth, [NAME] | A01428077 | Math |  |  |  |  |  | 11-12' | 12-13'
[NAME], [NAME] | A01435425 | Math |  |  |  | 11-12" | 12-13'
Hosea, Phebe | A01435450 | Math |  |  |  |  | 11-12' | 12-13'
[NAME], [NAME] | A01427218 | Math |  |  |  |  |  | 11-12' | 12-13'
Khoddam, Kambiz | A01433306 | Math |  |  |  |  |  | 11-12' | 12-13'
[NAME], Candice | A01432054 | Math |  |  |  |  |  | 11-12' | 12-13'
Kirchgraber, [NAME] | A01433885 | Math |  |  |  |  |  | 11-12' | 12-13'
Kojima, Tetsuro | A01432353 | Math |  |  |  |  | 11-12' | 12-13'
Loyd, [NAME] | A01432099 | Math |  |  |  |  | 12-13' |  | 11-12'
McDonald, [NAME] | A01433110 | Math |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01425504 | Math |  |  |  |  | 11-12' | 12-13'
[NAME], [NAME] | A01424811 | Math |  |  |  |  | 11-12' | 12-13'
Nitta, Akira | A01433861 | Math |  |  |  |  | 12-13' |  | 11-12'
Parra, [NAME] | [NAME] | Math |  |  |  |  | 12-13' |  | 11-12'
Pop, Horia | A01425623 | Math |  |  |  |  | 12-13' |  | 11-12'
Scholars, [NAME] | A01426008 | Math |  |  |  |  |  | 11-12' | 12-13'
Summers, [NAME] | A01432255 | Math |  |  |  |  | 12-13' |  | 11-12'
Sun, Christine | A01432666 | Math |  |  |  |  | 11-12' | 12-13'
Takashima , [NAME] | A01432420 | Math |  |  |  |  |  | 11-12' | 12-13'
[NAME], Santiago | A01432829 | Math |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01430182 | Math |  |  |  |  | 11-12' | 12-13'
Tran, [NAME] | A01435200 | Math |  |  |  |  | 12-13' |  | 11-12'
Troxell, Cameron | A01432667 | Math |  |  |  |  | 11-12' | 12-13'
Vo, [NAME] | A01432399 | Math |  |  |  |  |  | 11-12' | 12-13'
Wakefield, [NAME] | A01432400 | Math |  |  |  |  |  | 11-12' | 12-13'
[NAME], [NAME] | A01426509 | Math |  |  |  |  | 11-12' | 12-13'
Zicree, [NAME] | A01434166 | Math |  |  |  |  | 12-13' |  | 11-12'
Young, [NAME] | A01436945 | Math |  |  |  | 11-12" | 12-13'
Rickard, [NAME] | A01436936 | Physics/Engr |  |  |  | 11-12" | 12-13'
[NAME], [NAME] | A01432398 | Physics/Engr |  |  |  |  |  | 11-12' | 12-13'
[NAME], M Z | A01425145 | Physics/Engr |  |  |  |  | 11-12' | 12-13'
Mason, [NAME] | A01433112 | Physics/Engr |  |  |  |  | 11-12' | 12-13'
Schnurbusch, [NAME] | A01433113 | Physics/Engr |  |  |  |  |  | 11-12' | 12-13'
Tatoian, Vahe | A01424907 | Physics/Engr |  |  |  |  | 12-13' |  | 11-12'
[NAME], [NAME] | A01428766 | Physics/Engr |  |  |  |  | 11-12' | 12-13'