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

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